Limit scope of Rows(x).Copy to a specfic # of columns

The Rows(TemplateRow).copy statement below puts the entire template row (with all my formulas and formats) into the clipboard memory. Is there an alternative copy syntax that would limit it to, say 65 columns? The purpose of this code is to add a user determined # of rows to a named range, then copy and paste the template formulas into the new blank lines.
The reason: Once the file is saved by a 2010 user, the .insert Shift:=xldown will intermittently fail for a 2003 user.

Please Login or Register  to view this content.

You could try Resize.

Please Login or Register  to view this content.

By the way, I don't see how restricting the no of columns would prevent an error caused by shifting rows down.

I don't see how either, but for some reason the code works in 2010 and not in 2003. I was thinking about resize, but I also need to actually insert new rows into the named range that contains that template row. I neglected to specify that. Will resize do that or will it just paste? I think it will just paste the template

maybe instead of doing the insert and copy/paste all in one operation, I should separate it into two steps - insert the complete lank rows, then copy and paste the defined # of columns

Splitting it up probably is a good idea.