chris2727272727
Board Regular
- Joined
- Jul 10, 2005
- Messages
- 152
Range("d14").Formula = "VLOOKUP(H14,'\\Office_server\My Documents\Thames Valley\[Thames Valley Database.xls]Employee Contacts'!$B$16:$I$137,2,FALSE)"
the above works when emtered in excel on the sheet itself but when yhou switch to vba mode and try to input it it does not can anyone explain why???
am i correct in thinking range.formula is the right way to put a formula in cells
the above works when emtered in excel on the sheet itself but when yhou switch to vba mode and try to input it it does not can anyone explain why???
am i correct in thinking range.formula is the right way to put a formula in cells