Be Excellent To Each Other

OK so it's probably 10 years since I did any proper VBA programming in Excel and that area of my brain has now been overwritten with which corners I need to drift on in Outrun 2.

So needs the helps.

I've got a spreadsheet which calculates the commission on sales for stuff and there's a separate sheet for a package deal which adds the component parts together. Currently when the package is complete it is meant to copy the existing sheet to a new one then clear the blank rows in the original and rename it for future reference.

My macro works all the way from here

Sheets.Add 'creates new sheet
Sheets("Sheet1").Move After:=Sheets(4) 're-organises tabs
Sheets("Package").Select 'selects Package sheet
sheetname = InputBox("Name for current Package?") 'asks user for existing package name
Sheets("Package").Name = sheetname 'renames the sheet according to above
Range("a1:o12").Select 'selects the range that contain the calcs
Selection.Copy ' copies them to the clipboard
Sheets("Sheet1").Select 'goes to the new sheet
ActiveSheet.Paste ' and pastes it in

Then when it gets to

Range("A2:A11,C2:C11,D2:D11,F2:F11,H2:H11,L2:L11").Select 'selects the cells that contain the variables

I get a 1004 run time error of the superbly vague 'application-defined or object-defined error.'

I get the same if I just pick a single cell for the range.

Why it no worky?

I ran though it roughly on my machine and it worked so I'm not sure. Will work?

It shoudln't, there's nothing wrong with A2:L11.

Try

And give it capital letters, just in case.
If not, try

It only fucking well does.

Thanks bloody heaps.

Fucking VBA. Could have been the capitals.

YEAH, IN YOUR FACE GRIM...!!!!!!111!!11

Cool. No idea why your original code didn't work though because it went though fine on mine. Took a guess really.

It hates you (it's number 78 on the Outrun 2 leaderboard).