hiding rows of data

[mark gardner]

I have a sheet where I have data in a row, followed by a calculation row, followed by a data row etc... (keeps alternating). I would like to know if there is a quick way to toggle those calcution rows off and on to hide them when I don't need them. I have to keep manually hiding the rows now.

 

[daniels012]

You can create a button to do this, adding some code like this:

Range("3:3,5:5,7:7,9:9,11:11,13:13,15:15,17:17").Select
Selection.EntireRow.Hidden = True

Then one to unhide them all the same way

Michael

 

[DRANDON]

assign macro to a button -

sub Hide_Rows()
dim i

for i = 20 to 2 step -2 ' starts at row 20 and ends at row 2
rows(i,i).select
Selection.EntireRow.Hidden = True
next i

end sub