Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » End(xldown)
Resolved · Low Priority · Version Standard
Ashish has attended:
Excel VBA Intro Intermediate course
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?
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
|
Excel tip:Removing the Ribbon from view in Excel 2010At 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. |
We'll call during UK business hours
Server loaded in 0.07 secs.