Hi everyone
Im trying to make a selection from a specific cell untill the last row and last column of the sheet. I have the letter of the last column which is "DS'' but now i want to use this in my range selection.
Anyone knows the answer?
Please Login or Register to view this content.
I am not sure that I understand... You are selecting G3:DS... but your description says A1 to last row and column
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
I am not sure that I understand...
Try...
Please Login or Register to view this content.
Thank you Arkadi! Your solution works perfectly. Im sorry for the A1 in the description, I thought the tread would be easier to find in the future.
Also thank you JCabral for the response your solution also works perfect! Now i have to choose between two haha.
Thanks for the feedback. With this code it would not really matter which one you choose, it is not very demanding.
I humbly suggest that mine is SLIGHTLY more efficient, since it removes the line of code that obtains the letters for the column, which is not really needed.
Veel geluk me je projekt!
Thanks for marking the thread as solved, and for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks