I would like to create a macro to Loop through a range from cell AH4 to cell AH10000 on Sheet7 in a workbook (sheet name "CALCULATIONS"). I want to ensure that for all cells in the range AH4 to AH10000 that include numeric values, the row for that cell is unhidden. In addition I want to ensure that for all cells in the range that are non numeric, the row for that cell is hidden. The data is sequential in that after the first non numeric result occurs, all the following cells to the bottom of the range will also contain a non numeric result (either text "No data" or an error value).
I have tested a lot of different code to try and resolve this but haven't managed to make anything that works well. My initial thought was to use Do Until in relation to the first appearance of a non numeric result, from that point it should be possible to select all rows from the current row to row 10000 and hide them in a single action. That seems an efficient way to approach this if it stops the loop through every remaining row in the range. However, I am stuck. If anyone can assist I would be very grateful
I have tested a lot of different code to try and resolve this but haven't managed to make anything that works well. My initial thought was to use Do Until in relation to the first appearance of a non numeric result, from that point it should be possible to select all rows from the current row to row 10000 and hide them in a single action. That seems an efficient way to approach this if it stops the loop through every remaining row in the range. However, I am stuck. If anyone can assist I would be very grateful