If Found then do something

[ptmuldoon]

As part of a larger script, I'm attempting to search a worksheet for the word "Debit" And then if found, I want to loop through a range of cells in that column and the column next to (Credit)

I put this together and it works. But I'm guessing there is may be an easier way? I'm currently first searching, and then activating the cell to get the column number/letter and then working with offsets.

Please Login or Register  to view this content.

[stnkynts]

Please Login or Register  to view this content.