Thread: Noob Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default Noob Question

G4.Value and G1.Value should both be
Range("G4").Value and Range("G1").Value because G4 and G1 are not objects -
Excel sees them as undeclared variables, hence Variants.
Instead of IsEmpty(Range("D3").Value) you want IsEmpty(Range("D3")) (no
".Value)
HTH

"O...." wrote in message
...
I'm Getting Object Required. Run Time Error '424' . Trying to evaluate a
cell and If it's Null do the calculation MyItem = (Month(Now()) / 12 *
G4.Value) and place it cell G1 and if it's NOT Null use the Value in D3
Cell
which is a date and Replace the Now Function in my Calculation. Thanks
for
the Help in Advance. O....

Sub MyEvaluate()
Dim MyItem As Long
If IsEmpty(Range("D3").Value) Then
MyItem = (Month(Now()) / 12 * G4.Value)
G1.Value = MyItem
End If
End Sub