How do I write code so that my macro selects all used rows? For example, I have to import data into an Excel workbook every morning and the number of rows are never the same. I need to select all used rows (I do this by manually with ctrl + shift + down arrow) and adjust the row height to 60.00. How do I write this in VBA?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel Facts
Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
