Hi, I want to check a range of cells for a text, text is in one of the cells, and I want excel to be able to identify which row the text is in. Range is from columns "AB:BB". I just put 500 in the loop just to count down the rows. The range is not beyond row 500. Thanks.
Here is my current code: