Hi Tom,

Thanks for getting back to me, I appreciate it.

On both the examples I receive a the following error message:

Compile error - Syntax error

The error occurs at the following lines:

Example 1 - set bk = Workbooks.Open sStr(i), UpdateLinks:=0

Example 2 - set bk = Workbooks.Open Range("A1").offset(i-1,0) _
.Value, UpdateLinks:=0


Have I overlooked someting? Thanks for your help

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=39826