Formula or value

  • Thread starter Thread starter Mike D.
  • Start date Start date
M

Mike D.

Is there a formula I can use to check if the value in another cell is an
actual value or a formula that generates a value?

In column "E", I have about 1,000 rows of values. Some of these values
have been typed in and some have a VLOOKUP formula that generates the value.

I am looking for a formula that I can put in column F that will tell me if
the value in E is a VLOOKUP formula or not ...
 
A simple macro
Sub Findformulas()
For Each c In range("e2:e1000")
If c.HasFormula Then MsgBox c.Address
Next
End Sub
 
Hi Mike,

The simplest way is to tap Ctrl+`
(which is the button just left of 1 on your keyboard)

That will display all of your formulas so as to see
what is happening.

If you are looking for something more than that
post more detail.

HTH
Martin
 
How about an alternative.

Select column E
Edit|goto|special
check Formulas and ok
Now only the formulas are selected.
Give them a nice fill color

You could do the same with Constants if you wanted to color them instead.
 
Back
Top