Hi,
I have a VBA script that searches each cell of a column set by a range for a specific word.
What I want to do is when the word is found, select a range on the active row.
Unfortunately, my workplace will not allow me to upload the spreadsheet.
So:
The script will be used on different spreadsheets, the number of columns used will not always be the same.
My script searches the firs word for the column heading "File Path" and then searches that column for the word "Test".
(all the above works fine, the next section is what I cannot get correct)
When the word "Test" is found I need the script to;
Move to the first column of the active row and select the cells of that row up to the last non-blank cell.
I cannot use the standard 'Offset' function because the column I am searching could be different each time.
I have tried
The end result is the script will search for a word in the column.
If it finds the word, select that active row up to the last non-blank cell.
'Fill' the select cells so that they stand out.
Thanking you in advance
Bookmarks