Ideas?

[craigglasgow]

Hi, so im pretty new at programming but im needing to write a code and im at a loss at how to achieve it.

The code has to be written to be able to extract a range of values from a closed excel doc, then using this range many equations within vba.

sorry being so vague its hard to describe.

i have tried using a for each In statement and also using arrays but i cant get my head round it.

Any help would greatly be appreciated

Thanks

Craig