VBA to locate first cell in range that contains a formula

[EssKayKay]

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

 

[MARK858]

Maybe...

Sub EssKayKay()
    Range("K33:K1233").SpecialCells(xlCellTypeFormulas, 23)(1).Offset(, 2).Select
End Sub

 

[EssKayKay]

Maybe...

Sub EssKayKay()
    Range("K33:K1233").SpecialCells(xlCellTypeFormulas, 23)(1).Offset(, 2).Select
End Sub

Excellent! Thank you very much Mark - that did it.

 

[MARK858]

You're welcome

 

[Peter_SSs]

Excellent! Thank you very much Mark - that did it.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[EssKayKay]

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

Got it - sorry