if your data in in a range named 'Source' and th eprint table is called
'Target' then

Sub Main()
dim rSource as Range
' copy the data
SET rSource = Range("Source")
With Range("Target").Resize(rSource.Rows.Count,rSource. Columns.Count)
.Value = rSource.Value
End With
' now print it
rSource.PrintOut
End Sub




"neilwebb" wrote:


HELP!!!!!

I want to be able to automatically print a label from excel when i
input data.

the data will be sent to excel automatically from a software package
called winwedge.

once this data arrives in excel i need excel to do three things with
it.

firstly, i need it to log this data with all the other data to form
graphs - this isnt a problem.

secondly, i need excel to take a copy of this data and paste it into a
pre defined area ready to print.

and thirdly, once the information is inpuuted into the predefined area,
i need it to print automatically.

this seems unlikely to me, but im sure there is someone out there who
can tell me if it is possible or not??????

many thanks

neil


--
neilwebb
------------------------------------------------------------------------
neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450
View this thread: http://www.excelforum.com/showthread...hreadid=380468