Question about Microsoft Office Standard for PC

1 Answer

Excel 2003 / 2007 vba code

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
End Sub
~~~~~~~~~~~~~
It bombs on the "Copy After" line.

Posted by on

  • geekware May 11, 2010

    The code is not with your question. I need to see it before i can help.

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 23 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...
Microsoft Office Standard for PC Logo

239 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18343 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...