Hi all.
I am trying to get to the last row in a table of data. However the last few
rows are hidden and it is the visible row that I want to go
If do cells(1,1).end(xldown).row
however this will stop at the last visible cell
if I do cells(1,1).end(xldown).end(xldown).row
it takes me to the very last cell in the spreadsheet
I can't take advantage of the usedrange as there is other data lower down on
the spreadsheet that needs to remain.

Any help would be much appreciated

thanks in advance.

regards,