hi,
i have a code to print out sheet from 1 page to range c1.value
if c1.value = 2 then it will print page from 1 to 2
if c1.value = 5 then it will print page from 1 to 5
if c1.value = 7 then it will print page from 1 to 7
now i have having a problem here after successfully applied above code now i want to start printout from column(P) instead of Column(b)
Please Login or Register to view this content.
thank you
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
For that you need to set your Print Area. Read up on that.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
thank admin for reply
actually i want to trying like this
i want to start FROM page 10 TO ws.range("h1").valuePlease Login or Register to view this content.
That syntax looks correct for that requirement.
oops!
yes you are right
i added just OnErrorResumeNext
and its working nowPlease Login or Register to view this content.
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks