I have a number of large spread- sheets. I need to format the row height of every fourth row to 24.00
I have the macro below which doesn't work. Can anyone fix it please?
Sub Height()
X = 0
Do
X = X + 4
Rows(X).RowHeight = 24
Loop Until X = 1000
End Sub
Thanks Steve..![Mad :mad: :mad:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f621.png)
I have the macro below which doesn't work. Can anyone fix it please?
Sub Height()
X = 0
Do
X = X + 4
Rows(X).RowHeight = 24
Loop Until X = 1000
End Sub
Thanks Steve..
![Mad :mad: :mad:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f621.png)