I have an Excel workbook with multiple columns and thousand and thousand
rows of data. I want to create a function to loop throught two of the
columns to find a pre-defined search word and replace it with something. I
want to create this in a function on a button. I am new to Excel coding, the
part That I am not sure is how to loop throught a select range (column) to
the end of the row on that column to find the serach word and then it moves
to the next column and finish it to the end of the row of the second column.
Thanks.