Hi gurus,
I have selected range stored in range variable. The selection is user determinable. I am trying to identify row and column addresses of first cell in the range and last cell in the range. Can you please suggest code for this?
I appreciate your advices.
Thank you
Roshan
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Let's say your Range variable is named Rng, then the addresses you asked for are...
First Cell: Rng(1).Address
Last Cell: Rng(Rng.Count).Address
If you want to skip the variable and use the selection directly, then...
First Cell: Selection(1).Address
Last Cell: Selection(Selection.Count).Address
Last edited by Rick Rothstein; 01-22-2021 at 07:30 PM.
Hello Roshan,
Please Login or Register to view this content.
Or if you have the selected range stored in a variable, then assuming r is the range variable you could use this:
Please Login or Register to view this content.
Looks like Ricks is the shortest and best way here though :-)
Thanks Rick.
I never knew about that.
Please Login or Register to view this content.
Thank you all.
You are quite welcome... and thank you for the Reputation Points.Originally Posted by Roshan.Shakya
Thank you all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks