I'm trying to use Loop until to find a cell containing a particular word and then use an offset function. However, sometimes when I am looking for the word it may not actually exist. I was wondering if there was any form of "Loop Until Or" statement I could use to specifiy that if the cell didn't contain the word I was looking for, but instead was blank I could continue the macro
The code I'm using is below. (I've Dimmed RiskCurrency as a string elsewhere) If I don't find RiskCurrency but I find a blank cell I'd like to continue.
Apologies if this is really straight forward.
Thanks for any help in advance
Bookmarks