Hi Darren,

I'm confused, I thought you wanted to 'goto' the first cell including or
below B10 that is not in a (filtered) hidden row. In light testing that's
what the macro did.

which I know will
always be one line beneath row 10, column 2

so why not go directly to B11, guess I'm not following.

Regards,
Peter T

"Darin Kramer" wrote in message
...
HI Peter,

Thanks - this takes me to the last row in the range, which is blank - I
want it to take me to the first row with data in it - which I know will
always be one line beneath row 10, column 2 (In prev eg I know I used
used b1, but its actually B10)....

Thanks!!!

Regards

D



*** Sent via Developersdex http://www.developersdex.com ***