Printing Procedure Problem

[sunnytahir]

Dear Sirs,

I have a list in excel in 12 columns and several rows, First column contains order no's. in (text type format)

When the user presses the print button on the worksheet, the cell pointer moves to first column of active Row
and data of active row is copied on other worksheet ( which contains a specific format ) and printed.

I want when user selects the 3 or 4 order no's - all 3-4 order should print.

In other words I want to print 3-4 orders in specific format at the same time.

Thanks in advance.
Tahir

 

[PHV]

Have you tried to use the Selection.PrintOut method ?

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

 

[sunnytahir]

Dear PHV,

I am Sorry, I think i could not explain my procedure clearly. I want a loop that can print one row's data in specific format and then the other line should start.

Thanks.
Tahir

 

[PHV]

Have you tried the macro recorder to get a starting point ?

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

 

[sunnytahir]

Dear PHV,
Thanks for your help.
I tried it but, it can print only one rows data at time.
Best regards.
sunny