VBA to Autofit Row Height on multiple sheets

[mkmiller]

I'm looking for a macro that will Autofit row height for cell ranges on select sheets in my workbook. Ideally if the macro could reference a tab with a setup table containing the sheet names and cell ranges to format I think that would work best for me. I'm having difficulty finding something that would allow me to specify the ranges and sheet names. Thanks for your help!!

 

[dermie_72]

have you tried recording a macro of the actions you requested and then adjusting the code to suit.