• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to custom print data from various tabs

R

ramsy

New Member
hi..

i have data in four tabs and i want to print the data by using an ActiveX or form control button in a different tab...

im week in VBA programming so any help on this front will be appreciated :)


Regards

Ramakanth
 
Hi Ramakanth ,


Look up the PrintOut method , as it applies to a Range object ; thus you can have your print ranges defined by named ranges Print_Range in the different worksheet tabs , and have 4 command buttons ( ActiveX or Form control buttons ). In their Click event code , have the statement


Print_Range.PrintOut


In case you want more information , please ask.


Narayan
 
You must log in or register to reply here.
Back
Top