Hide Rows based on Cell Value

Hi All,
I'm using the following code to hide a row based on cell value in that row. The code works fine but I'd like to not use this repeat code for lines 19 through 58. I know that if, say for example, line 21 is <0 then the rest of the lines to 58 will be <0 as well and will need to be hidden. Is there a simple if-then-next type of check I could use to shorten the amount of code I would need to put in the way I currently show it? Thanks for the help!

Please Login or Register  to view this content.

I'm not great at VBA, still learning, and don't know the exact syntax for this suggestion, however I would imagine you could use a for...next loop to go through the cells one by one

Please Login or Register  to view this content.

Thanks Speshul,
I've moved to a different approach with the code below but am getting a syntax error. Do you have any thoughts as to why? I'm trying to set the row to start on as maxarray. The error pops up in this line: Sheets("Seismic Data H1").Rows(MaxArray&":58").Select

Please Login or Register  to view this content.