Forum Discussion
Autofit Row Height when sorting
When a worksheet contains rows with different heights, I would expect those heights to be automatically adjusted during a sort of the rows in that sheet. Alas, this appears to not be the case (At le...
NikolinoDE,
When looking at your formula above in black... I highlighted my entire sheet and typed just as yours above, which did not work. Should I replace some words with my excel worksheet/tab name?
When looking at your formula above in black... I highlighted my entire sheet and typed just as yours above, which did not work. Should I replace some words with my excel worksheet/tab name?
So it works for me (Excel 2016). Did you save the file as .Xlsm?
- As far as I can gather from your text, you are connected to a server. Files with VBA could be locked in the network. What and what options you have available, you should contact your administrator, the .xlsm files with VBA code could possibly be blocked for network security reasons.
It is always an advantage if users are informed about the Excel version, operating system and storage medium in advance. Beneficial for him as he could get a faster and more accurate solution suggestion and it is beneficial for the user who wants to suggest a solution to you.
Furthermore, I wish you much success with Excel. - Dont think that is going to work either. we have the site you mentioned blocked and onedrive is only for internal docs only
No luck
- Which excel version is used?
If you are using excel for web you cannot edit VBA code only execute.
If you have no possibility add a file here.
You can use OneDrive, or any other internet option
.. try that too https://easyupload.io/ - thanks anyways 😞
NikolinoDE It will not let me attach the file. I have tried and it shows that it is not supported.
- Right off the bat I can't suggest a solution to you, I could only give you guesses that might be very time-consuming. Please paste the file with the problem (and without sensitive data), that would help both of us to see where the error in this file could be.
NikolinoDE I was able to get it to work on one of my workbooks and actually was able to remove column autofit and it still worked after sorting multiple different ways. Now my issue is.... I cant get it to do the same thing on another workbook by following the same exact example. It is odd. I have saved my add in and tried that as well with no luck. What am I doing wrong?