LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Need Macro to print curent page only

JW,

I am using Excel 2003. What is your e-mail? I will send you the workbook.


"JW" wrote:

On May 12, 2:59 pm, Don Lowe
wrote:
JW,

I have tried the code you gave me. I continue to get "Run-Time Error 9".
Then I can not get it to work when I go to debug the highlighted area:

Loop Until x = iCols _
Or y < .VPageBreaks(x).Location.Column

What am I doing wrong?


Not sure. Works just fine for me here. What version of Excel are you
running (I'm running 97 and 2003)? You can send me your workbook
containing the code and I will take a look at it.

 
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
How to create a macro to print a page? Matt Excel Discussion (Misc queries) 2 May 14th 09 09:46 PM
Setting the print area in page set up to print 1 page wide by 2 pages tall EA[_2_] Excel Discussion (Misc queries) 2 July 12th 07 08:39 PM
Macro for Print Odd and Even page emil Excel Programming 2 May 2nd 06 09:04 PM
Macro to print web page and close browser Oreg[_61_] Excel Programming 6 April 8th 06 11:29 AM
Excel Print Page setup macro... hord Excel Programming 0 January 22nd 04 01:01 AM


All times are GMT +1. The time now is 09:18 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"