Hi, i'm writing a very long procedure that will automate a long manual
task. The task involves copying and pasting raw data from many
different workbooks into other workbooks. I started the code from
scratch and because of my limited excel vba knowledge have used the
method of declaring a workbook variable as either a name or
active.workbook and then using something like wb1.activate to point at
correct book.

As my code grows ive noticed im using this statement a considerible
amount of times and was wondering if there was another method i should
be made aware of before its to late to change?


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=538000