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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofit row height when retrieving text via formula 3
Pasting cell contents into a macro 1
Auto fit wrapped and merged cells in entire worksheet 8
ActiveWorkBook versus ActiveSheet 5
macro to generate next number 9
How can I get a macro to populate the answer into one specific cel 3
After Macro runs, no cell activated - what am I missing? 2
Macro in Excel 2

Top