Question Locked

Excel 2003 VBA: ranges and formulas

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am attempting to write a macro using a named range and a formula. The named range is on one worksheet already. The line of code for the formula looks like this:
ActiveCell.Formula = "=vlookup(e4,'neworders.xls'!items,3,False)-f4"
I am dealing with the folloing range: Range("[neworders.xls]!items")
Any help, as this doesn't seem to compile.

1 reply

This discussion is closed to new replies.