Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#VALUE! position in column of data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#VALUE! position in column of data
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 "Todd Huttenstine" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row position of specified column and value | Excel Worksheet Functions | |||
How insert a dash in the third position of a column with data? | Excel Discussion (Misc queries) | |||
function for Column Position | Excel Discussion (Misc queries) | |||
Finding Column Position | Excel Discussion (Misc queries) | |||
locking data/cells so re-sorting a column doesn't re-position my d | Excel Discussion (Misc queries) |