| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print area poser
need to know if this is possible want to automatically print data from sheet 1 via a print area in sheet2 once it has printed the data, i need it to clear this data and read from another row on sheet 1 all in all i need a single row print area in sheet 2 to read from about 50 different rows in sheet 1. dont think its possible myself but what do you reckon???? regards neil -- neilwebb ------------------------------------------------------------------------ neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450 View this thread: http://www.excelforum.com/showthread...hreadid=386066 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
print area poser
If you are putting the data in Sheet1 with a macro, then at that point,
define the printarea in sheet 2 based on your macros knowledge of where it put the data in sheet2. then issue the print command. Beyond that, you information is too vague to imagine what you want to do. -- Regards, Tom Ogilvy "neilwebb" wrote in message ... need to know if this is possible want to automatically print data from sheet 1 via a print area in sheet2 once it has printed the data, i need it to clear this data and read from another row on sheet 1 all in all i need a single row print area in sheet 2 to read from about 50 different rows in sheet 1. dont think its possible myself but what do you reckon???? regards neil -- neilwebb ------------------------------------------------------------------------ neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450 View this thread: http://www.excelforum.com/showthread...hreadid=386066 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
print area poser
You have a couple of replies to your posts in .excel.
neilwebb wrote: need to know if this is possible want to automatically print data from sheet 1 via a print area in sheet2 once it has printed the data, i need it to clear this data and read from another row on sheet 1 all in all i need a single row print area in sheet 2 to read from about 50 different rows in sheet 1. dont think its possible myself but what do you reckon???? regards neil -- neilwebb ------------------------------------------------------------------------ neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450 View this thread: http://www.excelforum.com/showthread...hreadid=386066 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
print area poser
both of which agree that you have not provided enough information to provide
much help specific help. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... You have a couple of replies to your posts in .excel. neilwebb wrote: need to know if this is possible want to automatically print data from sheet 1 via a print area in sheet2 once it has printed the data, i need it to clear this data and read from another row on sheet 1 all in all i need a single row print area in sheet 2 to read from about 50 different rows in sheet 1. dont think its possible myself but what do you reckon???? regards neil -- neilwebb ------------------------------------------------------------------------ neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450 View this thread: http://www.excelforum.com/showthread...hreadid=386066 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
print area poser
Yep.
But after reading 7 messages in 5 groups. I wanted to give a warning that the message was multiposted. (and "you = OP" in this case??) Tom Ogilvy wrote: both of which agree that you have not provided enough information to provide much help specific help. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... You have a couple of replies to your posts in .excel. neilwebb wrote: need to know if this is possible want to automatically print data from sheet 1 via a print area in sheet2 once it has printed the data, i need it to clear this data and read from another row on sheet 1 all in all i need a single row print area in sheet 2 to read from about 50 different rows in sheet 1. dont think its possible myself but what do you reckon???? regards neil -- neilwebb ------------------------------------------------------------------------ neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450 View this thread: http://www.excelforum.com/showthread...hreadid=386066 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
| File, print area, clear area, is not working | New Users to Excel | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
| print area poser | New Users to Excel | |||
| print area poser | Excel Worksheet Functions | |||
![neilwebb[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
