Padawan018
Board Regular
- Joined
- Sep 29, 2006
- Messages
- 63
I am trying to enter a formula via VBA and I am receiving an error when I step through the code at this line:
Range("C1").Formula = "=if(iserror(vlookup(m1,'WBS to MPM Issue Table'!$C$2:$J$148,8,0)),"",VLOOKUP(m1,'WBS to MPM Issue Table'!$C$2:$J$148,8,0))"
I figured out that Excel is using my 'leave blank' quotes as the end of text quotes. Is there any work around for this?
Thanks,
Range("C1").Formula = "=if(iserror(vlookup(m1,'WBS to MPM Issue Table'!$C$2:$J$148,8,0)),"",VLOOKUP(m1,'WBS to MPM Issue Table'!$C$2:$J$148,8,0))"
I figured out that Excel is using my 'leave blank' quotes as the end of text quotes. Is there any work around for this?
Thanks,