LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default Macro to print screen

I have a spreadsheet, that contains many rows of data.(300)
A-M

When using the s/s I will filter to show the required data. I would expect
that once filtered the maximim number of rows would be no greater than 20

I would like to put a macro button on the s/s that would print just the
details filtered
and only show columns A-J

its a bit like set the print area and print, - but not that simple
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Screen Question on print screen New Users to Excel 1 July 11th 09 04:05 AM
can't print data labels - on screen but don't print out Linda Charts and Charting in Excel 1 June 27th 09 07:11 PM
Print Screen Richard Excel Discussion (Misc queries) 4 March 3rd 08 03:28 PM
print box opens in right screen of dual screen setup why gerrys Excel Discussion (Misc queries) 1 June 30th 06 06:47 PM
Print and Print Preview don't match screen JNohl Excel Worksheet Functions 0 March 11th 05 05:23 PM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"