LinkBack URL
About LinkBacks
Hello all,
How do I select a range in column G starting from the 3rd row till the word "total" occurs in column A?
Hello all,
How do I select a range in column G starting from the 3rd row till the word "total" occurs in column A?
The word "total" is always the last value in column A, so perhaps starting from the bottom and offset it with 2 to select the corresponding cell in column C.
Now I need to resize the selection to the top of column C3
But I can't get it done.
Please Login or Register to view this content.
Any suggestions?
This?Please Login or Register to view this content.
You could use this to set the range for Column G based on the word "total" being in Column A
Where foundRange is the range from G3 to Gx where x is the row number where Column A has the word "total"Please Login or Register to view this content.
Edit - I did not see that total was always the last row in Column A - you would not need something as elaborate as above you would only have to find the last row number of column A
Did not read your second postPlease Login or Register to view this content.
Last edited by smuzoen; 01-24-2012 at 08:33 AM.
Hope this helps.
Anthony
Pack my box with five dozen liquor jugs
PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?
Please Login or Register to view this content.
Thank you guys,
I used StephenR's code, works fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks