Question about Microsoft Office Standard for PC
This code bombs in excel 2007 but works in excel 2003. I need it to work in both.
Dim NewPageName As String
Sheets("Lab Work Order Master").Visible = True
Sheets("Lab Work Order Master").Copy After:=ActiveSheet
NewPageName = InputBox("What would you like to call your new Worksheet")
ActiveWindow.ActiveSheet.Name = NewPageName
Sheets("Lab Work Order Master").Visible = False
It bombs on the "Copy After" line.
A similiar thing happened to me once and I used the format
"Sheets("Lab Work Order Master").Copy(,ActiveSheet)" instead of
"Sheets("Lab Work Order Master").Copy After:=ActiveSheet"
You may also want to try using a sheet index instead of "ActiveSheet" to refer to your sheet.
P.S. Don't forget to rate me. Wish you the best.
Posted on Dec 12, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
243 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: