Copy Sheets
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Copy Sheets

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a worksheet that has several ActiveX controls. What is the most expediant way to copy this sheet and place it before the sheet that is being copied? I have tried

    ActiveSheet.Copy

    It takes about 10 seconds to copy. Is there another way to copy the sheet that will be faster?

    Any suggestions?
    Thanks in advance,
    Patrick

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    OKC
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sub Macro1()
    Sheets("Sheet1").Copy Before:=Sheets(1)
    End Sub

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm sorry. I should have been more specific. The code I am currently using is:

    ActiveSheet.Copy Before:=Sheets("Start")

    This takes between 10 & 15 seconds to copy the sheet because it has about 15 ActiveX controls on it. Is there anyway to speed this process up?
    Thanks in advance,
    Patrick

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I can't get any other method to work other than what I have already tried. Any ideas?
    Thanks in advance,
    Patrick

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I really need some help with this. I have looked at various website regarding making code run faster but can't find anything on this specific topic.
    Thanks in advance,
    Patrick

  6. #6

    Join Date
    Apr 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

    No...sorry doesn't really help.

    Guess this is a lost cause??

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com