Hi All,
I am after a script that will find the last instance of the word Yes within Column A of a worksheet.
The word Yes may be in column A 1000+ times and there are blank/ empty cells (non contiguous) in column A also.
I would run the code using a macro button on the spreadsheet.
I have...