Hi

Do you want to print 50 pages with one row
Am I correct ?



--
Regards Ron de Bruin
http://www.rondebruin.nl


"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=386067