gruntingmonkey
Active Member
- Joined
- Mar 6, 2008
- Messages
- 434
- Office Version
- 365
- Platform
- Windows
Hello all, I need to place a formula into a cell via VBA where there are some variables but I keep getting "False" as the response rather than it pasting in the formula to the cell. Anyone have any ideas on how to rectify my code?
VBA Code:
Cells(LastrowRat, 44).Formula = "" = " VLOOKUP(AD" & LastrowRat & ",'Rates Log'!B:L,'Rates Log'!$D$2,FALSE)"""