I’m not sure this is possible but what I’m looking for is a VBA routine to go to the next cell in a range that contains a formula. Range K33:K1233 contains formulas. As time progresses the beginning cells are converted to values (K33, K34, K35, etc.). When I run a routine via a command button, I want the active cell to be the first cell in the range to be the cell that is a formula not a value.
Now let’s muddy the waters here a bit more. I actually want the active cell to be two columns right of the cell that contains the formula. That is, if the first cell with a formula is K42, then I want the active cell to be M42.
Thanks,
Steve
Now let’s muddy the waters here a bit more. I actually want the active cell to be two columns right of the cell that contains the formula. That is, if the first cell with a formula is K42, then I want the active cell to be M42.
Thanks,
Steve