Hi all. I'm trying to reference another cell from another workbook within a formula in VBA.
What I'm starting out with is
That part works just fine. It takes the value four columns from the left of the active cell and subtracts 2% from it. What I want to do is replace the "-2%" part with a reference to a cell in another workbook which will already be open so that it subtracts that value instead of the 2%. What I've tried are:
and
Neither of those seem to work. The specific cell in the workbook I want to reference isn't important (it could be Q1, A1, B3, Z54, whatever) as is the ability to reference a cell of my choice.
Any help would be greatly appreciated!
Bookmarks