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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.