VBA Help

[keyboard1960]

Using VBA, how can I evaluate a cell for a value that contains a formula? Example(IF(I2=I3,IF(J2=J3,"",D2),"") returns a conditional value. My macro cannot distingush between the value and the formula. Help!

 

[NateO]

Hello Keyboard,

Well the default return of a range call in vba is the value, something like the following should work:

<pre>
If [i2] = [i3] Then
'do something here
Else: 'do something here
End If</pre>

Not sure what you're looking to have the vba perform...

 

[hedrijw]

Is this what you want to do?

Say [a3] contains the following formula:

=Sum(a1:a2)

Then

what = [a3].Formula

will return the formula

what = [a3]

or

what = [a3].Value

will return the value


If you just want to check if a cell contains a formula

If [a3].HasFormula = True Then
' ----- your code goes here -----
End If
This message was edited by hedrijw on 2002-09-01 17:15

 

[NateO]

The other thing you can do is to assign the evaluation to a variable then call the variable, which is done below in a msgbox:

<pre>
Sub Evl()
n = [IF(I2=I3,IF(J2=J3,"",D2),"")]
MsgBox n
End Sub</pre>