Excel 2003 VBA: ranges and formulas

By Jeninems ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums