hi,
i am using below code to print a sheet according to cell value
but
i want to apply this code to all of my sheets except two sheets ("of") and ("of2")
thank you
Please Login or Register to view this content.
hi,
i am using below code to print a sheet according to cell value
but
i want to apply this code to all of my sheets except two sheets ("of") and ("of2")
thank you
Please Login or Register to view this content.
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 *
I found this code but its saying Method printout object worksheet failed
Capture.JPGPlease Login or Register to view this content.
In your first code you refer to Range("N3"), in your second code Range("N1"). Which is correct ?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Sorry for that mistake
N1 IS CORRECT
What's in N1 ? A value, a formula ?
Are there more than 2 sheets present ?
It's just because when I fill N1 with a value your code just works fine.
N1 = FORMULA
There is no limit of sheets
sheets generate according to my need?
yes there is more then two sheets presents
The only thing I can come up with is that the formula errors out on some page or another because for the rest your code is perfectly fine.
Also in your 1st post you talk about sheets of & of2, in your last code there's haroon & OF. maybe there's an error somewhere ?
Thank you for the reply
actually i want to skip two sheets with any name
I'll have to see the file that produces the error because I'm out of options.
Here is workbook
The problem is a hidden sheet named BAL.
oh!
not what to do ?
Because i don't want to show that sheet
Come on HaroonSid, this was an easy one even for you.
Please Login or Register to view this content.
Very very thank you Mr. bakerman2
works perfect
You're very, very welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks