Last Real Cell

  • Thread starter Thread starter franciz
  • Start date Start date
F

franciz

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,
 
hi
with this....
cells(1,1).end(xldown).row
you sould have gotten a invalid use of property error. I did.
try this...
cells(1,1).end(xldown).select

Regards
FSt1
 
Maybe just looping through the top table's first column would be best.

Or can you unhide the rows?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return last row no. of column with blanks at top 7
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy columns and paste with blank column between 5
End(xlDown) 5
summing through end of row 2
Changes in How Code Acts After Upgrade of Excel 2
Variation on the count row question 4
Can Vba workout if a selection is part of a group? 0

Back
Top