Hi All..
I have some problems on printing the worksheet..
Generally i have worksheet of the Client details.. what i want is that i want to set the print areas in such a way that only three of the client details get printed on Page one and another three client details on 2nd page and so on..
I have tried to set the multiple print areas by pressing CTRL and selecting the ranges but it is not helping me...
Can anyone help me out on this?
Thank you.
Have a nice day..
Selecting the different range of cells by holding Ctrl key and clicking Set Print Area is working fine for me
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
you can do
set print area three times as per your choice and give print command after each selection with vba
Kamboj
_________________________________________________________________________________
Mark the thread as SOLVED if my answer satisfy you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks