LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Variable row selection and printing

I have a workbook with two worksheets: sheet1, sheet2

I need a macro that selects sheet1 as the active sheet. I will need to
enter a starting and ending row using input boxes. A message box should
pop-up asking me to confirm the rows selected and prompting me to print the
rows.

For each row, copy only cells a:u. These cells will be pasted as values and
transposed vertically to a form on sheet2 in cells c3:c23. I will always
print sheet2 on a single page portrait however, I need to select the default
before the first page is printed. Subsequent rows will print to the default
printer. This loop should continue until all rows are transposed and
printed.

Finally, I need a message box to display the rows selected and a print count.

Thanks
 
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
printing selection Anniel Excel Discussion (Misc queries) 2 May 28th 10 09:06 PM
Using a variable to determine row selection [email protected] Excel Programming 3 August 21st 07 12:44 PM
Variable Selection Summation bodhisatvaofboogie Excel Programming 3 June 8th 07 02:57 PM
Selection of variable rows Archie Excel Programming 5 May 10th 06 10:50 AM
Variable for column selection Mats W. Excel Programming 2 July 14th 05 09:17 AM


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