Macro for changin row height

P

Prixton

Hi,
I am trying to make a macro that selects the entire sheet and then makes an
AutoFit. When doing so I want the active cell which can be any cell to be
the same after the macro is run. For me the active cell is always A1 after
the macro is run which is not what I want.

Thanks for every hint
 
P

Prixton

Thanks Don, that worked Ok. Now I tried ActiveSheet = 13 but that does not
work. Do you have a soulution for that too?

Thanks again
 
Top