You currWB variable is, I assume, a Workbook type variable. Therefore,
you can use it directly instead of Workbooks or you can use its name
with Workbooks. E.g.,

Workbooks(currWB.Name)......

' or

currWB.Sheets.(.....

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Thu, 09 Apr 2009 09:23:18 GMT, "Sri via OfficeKB.com" <u47062@uwe
wrote:

Hello,

I run a macro from currWB which produces the sheet "Overview".

Before I finish my macro, I need to copy this sheet into another workbook
destWB.

I use the following command but gettingthe error "subcript out of range".

Workbooks(currWB).Sheets("Overview").Copy After:=Workbooks(destWB).Sheets.
Count

Any help in this regard please ...???

Sri