VBA Error moving sheet

Analyze_This · Sep 21, 2011

Hey guys,

I'm writing a macro to move a worksheet from one book to another. Here's the part that's throwing the 'subscript out of range' error:

Code:

Sheets("Navigation").Copy Before:=Workbooks(CC).Sheets(1)

Pretty simple. The "CC" is a variable (dim string) that I establish earlier in the code. Any thoughts?

VoG · Sep 21, 2011

Does CC include the file extension like .xls?

Analyze_This · Sep 21, 2011

Good call. Thanks, buddy! For future reference, here is the code after VoG's suggestion:

Code:

Sheets("Navigation").Copy Before:=Workbooks(CC & ".xlsx").Sheets(1)