I'm getting Application-defined or object defined error at this point in some code I'm working on. Is there anything obvious that I'm doing wrong here ?
Range("Q2").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(E2,[C:\symtemp\TWOVRWold.xls]ProjMon'!E:P,12,FALSE)"
Terry
"... I thought I was a power user of Excel until I came onto these boards..."
Try and replace [C:\symtemp\TWOVRWold.xls]ProjMon'!E:P with simply WorkBooks("TWOVRWold.xls").Sheets("ProjMon").Range("E:P"). Is there any reason to quote the full path?
HTH
Myles
...constantly looking for the smoother pebble while the whole ocean of truth lies before me.
Try replacing ActiveCell.FormulaR1C1 with ActiveCell.Formula instead
The main reason as I understand for using the full path is that the TWOVRWold.xls will remain closed and not opened while the data is retrieved. So, Excel would need to know where the file is ???
Maybe I'm wrong ?
There also seems to be a missing single ' in your code.
"=VLOOKUP(E2,[C:\symtemp\TWOVRWold.xls]ProjMon'!E:P,12,FALSE)"
Should this be
"=VLOOKUP(E2,'[C:\symtemp\TWOVRWold.xls]ProjMon'!E:P,12,FALSE)"
Matt
Yeeeeeeeeeeeeee Haaaaaaaaaawwwwwwwwwwww !
You da king, Matt !
Thanks for pointing this out, this now works a treat. Strange though, because that was a recorded macro in the first place. Unless, I accidentally deleted it somewhere along the line.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks