Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Print some Sheets

Hi,

I need to write a code that can print some specific range of cells on of
some specific sheets is that possible ?
Can anyone help me to write this code ? Thanks,

Afshin


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Print some Sheets

Hi
why not record a macro while doing this manually :-)

--
Regards
Frank Kabel
Frankfurt, Germany

"A-Design" schrieb im Newsbeitrag
...
Hi,

I need to write a code that can print some specific range of cells on

of
some specific sheets is that possible ?
Can anyone help me to write this code ? Thanks,

Afshin



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default Print some Sheets

I imagine that you have tried turning on the macro recorder, selecting the
range to be printed, setting the PrintArea to that range, printing it, and
doing the same with the other sheets. In what way is the recorded macro
deficient for your needs?

--
Return email address is not as DEEP as it appears
"A-Design" wrote in message
...
Hi,

I need to write a code that can print some specific range of cells on of
some specific sheets is that possible ?
Can anyone help me to write this code ? Thanks,

Afshin




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Print some Sheets

You are right ,... Thanks for responses


"Jack Schitt" wrote in message
...
I imagine that you have tried turning on the macro recorder, selecting the
range to be printed, setting the PrintArea to that range, printing it, and
doing the same with the other sheets. In what way is the recorded macro
deficient for your needs?

--
Return email address is not as DEEP as it appears
"A-Design" wrote in message
...
Hi,

I need to write a code that can print some specific range of cells on of
some specific sheets is that possible ?
Can anyone help me to write this code ? Thanks,

Afshin






Reply
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 all sheets in one print job so I can staple them denman Excel Discussion (Misc queries) 2 August 3rd 09 10:59 PM
How do I print sheets in Excel without blank sheets after page Peggy New Users to Excel 2 January 12th 08 11:10 AM
Print Sheets in PDF Ed Excel Discussion (Misc queries) 4 October 18th 06 03:22 PM
i made one spreadsheet but when i try to print two sheets print, yokhan Excel Discussion (Misc queries) 1 August 14th 05 09:24 AM
Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook will Excel Programming 3 September 23rd 04 08:05 PM


All times are GMT +1. The time now is 07:35 PM.

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"