#VALUE! position in column of data

  • Thread starter Todd Huttenstine
  • Start date
T

Todd Huttenstine

I have a big range of data in column F. Each cell
contains a formula. If you start from the top and go down
you will eventually hit a cell that has the result of
#VALUE!. What code or formula will tell me the position
of this cell. For example range F5:F500 is filled with
formulas. The result of the formula in cell F341 is
#VALUE!. Tho code or formula need sto return 341. How do
I do this?


Todd Huttenstine
 
G

Greg Koppel

Sub test()
Range("A1").Select
Do Until ActiveCell.HasFormula = False
If ActiveCell.Text = "#VALUE!" Then MsgBox ActiveCell.Row
ActiveCell.Offset(1, 0).Activate
Loop
End Sub
 
Top