Im getting a 1004 error with this formula.
[VBA].Range("E25").Formula = "=VLOOKUP(YearsOfService,Indemnity,IF(Age<=65,7,14),FALSE),0)/12"[/VBA]
Im getting a 1004 error with this formula.
[VBA].Range("E25").Formula = "=VLOOKUP(YearsOfService,Indemnity,IF(Age<=65,7,14),FALSE),0)/12"[/VBA]
Peace of mind is found in some of the strangest places.
[vba]
"=VLOOKUP(YearsOfService,Indemnity,IF(Age<=65,7,14),FALSE)/12"
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks Bob
Peace of mind is found in some of the strangest places.
OOPS....Whats wrong with this:
[vba]With Sheets("CP1")
.Range("E25").Formula = "=(Indemnity!010/12)"
End With[/vba]
Peace of mind is found in some of the strangest places.
You have two zeroes, not the letter O
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber