Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Finding Current Address
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Finding Current Address
Resolved · Low Priority · Version 2003
Reply
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.For upcoming training course dates see: Pricing & availability
RE: Finding Current Address
Hi TonyThanks 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
|
