PDA

View Full Version : Solved: 1004 error



austenr
07-27-2010, 06:43 AM
Im getting a 1004 error with this formula.

.Range("E25").Formula = "=VLOOKUP(YearsOfService,Indemnity,IF(Age<=65,7,14),FALSE),0)/12"

Bob Phillips
07-27-2010, 06:46 AM
"=VLOOKUP(YearsOfService,Indemnity,IF(Age<=65,7,14),FALSE)/12"

austenr
07-27-2010, 07:13 AM
Thanks Bob

austenr
07-27-2010, 02:24 PM
OOPS....Whats wrong with this:

With Sheets("CP1")
.Range("E25").Formula = "=(Indemnity!010/12)"
End With

Bob Phillips
07-27-2010, 02:36 PM
You have two zeroes, not the letter O