Automatically hide rows If you are hiding the specified rows use the following code:

sub hiderow()

rows(15).hidden=true

end sub

The above code indicates that to hide the fifteenth row, if it is to be several consecutive rows can be used

sub hiderows()

for i=10 to 15

rows(i).hidden=true

next i

end sub

Sorry, I didn't pay attention to it, just replace columns with rows.

If you want to modify rows to integer multiples of 10 then do this

for i=1 to XXX 'XXX is your max rows or the max rows that need to be hidden by the following condition

If i Mod 10 = 0 then rows(i).hidden=true

next i