End(xldown)

Resolved · Low Priority · Version Standard

Thu 13 Mar 2008, 16:31 Delegate Ashish said...

Ashish has attended:
Excel VBA Intro Intermediate course

End(xldown)

If I have spaces or blanks in my data list End(xldown) will not work, how can I get this work (find the last row)with blank records at random points in my data?

Fri 28 Mar 2008, 09:38 Trainer Stephen said...

RE: End(xldown)

Hi ashish

Thank you for your question

If your table contains random blank records then the simplest approach is to use the current region property of the activecell object

The following code would select the surronding cells of cell b2, when this is a cell in the table

Range("b2").CurrentRegion.Select

Hope this is useful, if you have any further queries please do not hesitate to get back to me

Regards

Stephen

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips

End(xldown)

End(xldown)

RE: End(xldown)

Excel articles

Excel tip:

Removing the Ribbon from view in Excel 2010