Copy cells and print

[alring]

Hi there

I have a Excel document (1) where I make a calculation. In that document I also have a macro that opens another Excel document(2). In that macro I want to copy 4 cells from document (1) to document (2). I also want that the macro can print document (2).

I'm using Excel 2003.

Can somebody help me with that.
Thanks

Regards
Mads

 

[PHV]

As a starting point you may play with the Excel macro recorder to discover the objects involved.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[alring]

Hi PH

I could record it all.
Tanks