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
Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Similar threads
- Solved
