I have an open Excel file and using VB Script, I need to search only column "A" in the Excel sheet until it matches a text string. When the script finds that match, I would like to see the row number of the cell where the match was found.
Thanks for your helps in advance!
Excel – How to find the row number of a specific value in Excel using vbscript
excelvbscript
Best Answer
This is VBA to find the first instance of "test2" in column A of the activesheet. You can adjust the string and worksheet accord to your needs. It only counts as a match if the whole cell matches, e.g., "test2222" won't match. If you want it to, remove the ,
lookat:=xlWhole
bit: