You may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
David has some instructions that may help.
neilwebb wrote:
hi patrick
thanks very much for your reply about automatic printing.
how do i implement this information into my excel worksheet???
to refresh your memory, i have copied your reply below
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
the question i am asking is how do i get this information into my excel
spreadsheet???
regards
neil webb
--
neilwebb
------------------------------------------------------------------------
neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450
View this thread: http://www.excelforum.com/showthread...hreadid=380525
--
Dave Peterson