I'm attaching my spreadsheet to better understand what I'm trying to do.
I want to print the rows with data in them and not print the
rows with just the formula. My spreadsheet has 1000 rows with
formulas in them and I only want to print the rows which I have added
data. I know you can select print area and all that. But mainly it's
for the inexperianced user that might have trouble setting the print
area tab.
Would someone make changes to my spreadsheet to help me with this please.
Thanks Mike
All the rows appear to have data in them
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
It's the formula in column L causing it to print so many pages.
You could maybe use a workbook level BeforePrint event to set an autofilter on the sheet.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
to be quite blunt you'd have to be very inexperienced not to learn how to set the print area,if they cant learn that then im surprised they can use ms office at all! but try this in the workbook module
code quite shamelessly copied from here
Please Login or Register to view this content.
http://www.mrexcel.com/archive/Printing/30490.html
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks