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 several buttons that look for different words but I can modify a suitable script.
Thanks
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 several buttons that look for different words but I can modify a suitable script.
Thanks