column width, differences between methods

[Hein]

Hi all,
Yesterday I asked a question if, and how, I can adjust the width of multiple columns to their contents, and then add just a little more width for easier readability.
The code Ollie came up with (thanks again Ollie !) was:

Please Login or Register  to view this content.

This works fine, with 1 exception. If, in a large spreadsheet, i start eg in a name column and that name is shorter than the other entries, the new width of the column is relative to this smaller cell.
When I doubble click between the columns (even if I am in the same (short) cell, the column is adjusted to the longest cell in that column.

Is it possible to add this to the code mentioned above?

Thanks Hein

[HSV]

For the whole usedrange.
If there is nothing in the entirecolumn, the columnwidth will not changed.
All the other columns = autofit + 5.

Please Login or Register  to view this content.

[Hein]

Harry,

Sorry for my delayed answer, but I am glad you responded.

Your solution is exactly what I was looking for. Thank you for that
This will save me a lot of tedious work, and time

Again, thanks

Hein