Shananarocks
New Member
- Joined
- Jan 3, 2022
- Messages
- 5
- Office Version
- 2010
- Platform
- Windows
Hi, I am quite a newbie to MS Excel VBA although I can code quite well in MS Access.
Basically in Excel, I have a named range "NameAge" (A10:B20). I need to find the row that "Joe" resides.
However, most VBA codes will either result in giving me the last row which is row 20 of the named range or row 23 where "Charles" is.
Appreciate any help.
Thanks!
Basically in Excel, I have a named range "NameAge" (A10:B20). I need to find the row that "Joe" resides.
However, most VBA codes will either result in giving me the last row which is row 20 of the named range or row 23 where "Charles" is.
Appreciate any help.
Thanks!