This is no doubt a newbie question.
I have a subroutine which is parsed a range of unknown size.
I am searching the first column to find a value and when I find it I want to Select the row that this value is in, e.g. rRng (20x5) has 'Fred' in row 5, col 1.
I want to Select all of rRng row 5.
Note that I don't want to Select the whole row in the worksheet that the range is in. Just the row in the parsed range.
Seems dead simple but I can't find the answer.
Rhapsodie,
Please post your macro code.
At the beginning of your posted code, enter the following without the quote marks:
["code"]
Your code goes here.
At the end of your posted code, enter the following without the quote marks:
["/code"]
Have a great day,
Stan
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
rRng.Rows(5).Select
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks