Tony has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Intermediate course
Access Advanced course
Finding Current Address
How do you find the address of the current cell. I have a sheet that has several columns of data. However, one column is not always full. Using CurrentRegion will tell me how many rows of data ther are and I want to delete the lines that are not complete (they will always be the last ones). I can find the last entry by looking up the part complete column from the bottom of the sheet. However, I do not know how to find the address of this cell to then use in a delete rows routine.
RE: Finding Current Address
Hi Tony
Thanks for your question
The address property of the selection object will give you what you need. For example the code below will return the address in a message box
MsgBox Selection.AddressRegards
Stephen
