I probably have just developed a brain clot, but I am unable to make the following work:
Range("E22".Formula = "=IF(E20=0,0,VLOOKUP(List2!U80:V89,2,1))"
VBA seems to stick on the ! and using quotes or double quotes does not seem to work.
This is for a worksheet that I build on the fly populated with lots of excel coding and this is my only stickler.
Thanks for the help!!!!
Range("E22".Formula = "=IF(E20=0,0,VLOOKUP(List2!U80:V89,2,1))"
VBA seems to stick on the ! and using quotes or double quotes does not seem to work.
This is for a worksheet that I build on the fly populated with lots of excel coding and this is my only stickler.
Thanks for the help!!!!