Ah yes..that done the trick, thanks.
I have attached my sheet again, for some reason it is printing half a page of empty sheet, no fields filled in..why is that ?..if you have a look at in print preview what i have there i only want that to print out but it is printing a third page that has no values.
Hi Loady,
I changed it a little, what you do is copy the code, hit ALT+F11, doubleclick on "ThisWorkbook",type "Option Explicit" and paste the code under that - then every time you print it will readjust to the data that you have
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks