j.smith1981
03-31-2009, 08:35 AM
I am making an auto generating filter, by a variable.
What I am wanting it to do, pritty basic really, is select the first row of viewable data.
Loop down one column say the 1st column (1,1) then select the next until the viewable cells are empty.
Its not doing this at present its selecting the first row and it looping asif the rows where there with data in them through the entire sheet, not just the viewable rows, all 700 of them.
Does anyone know an exact way of making it loop through just the viewable cells please?
Thank you,
Jez
What I am wanting it to do, pritty basic really, is select the first row of viewable data.
Loop down one column say the 1st column (1,1) then select the next until the viewable cells are empty.
Its not doing this at present its selecting the first row and it looping asif the rows where there with data in them through the entire sheet, not just the viewable rows, all 700 of them.
Does anyone know an exact way of making it loop through just the viewable cells please?
Thank you,
Jez