Hi,

I'm trying to write a formula with VBA to add data from cells from an external Excel file using the GetOpenFileName method.

So far I keep encountering syntax errors.

For example, I want the activecell formula to add (sum) data from an external file Sheet2, cell AL23; Sheet2, cell AT17; Sheet2, cellAT24, etc.

Any help will be greatly appreciated, thanks!