Thu 13 Mar 2008, 16:31Delegate 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:38Trainer 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.SelectHope this is useful, if you have any further queries please do not hesitate to get back to me
Regards
Stephen
