Results 1 to 6 of 6

set NewSheet = OldSheet.copy

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2009
    Location
    holland, holland
    MS-Off Ver
    Excel 2007
    Posts
    3

    set NewSheet = OldSheet.copy

    Hello,

    I've created the folowing sub:

    Dim NewSheet as Worksheet
    Set NewSheet = OldSheet.Copy
    I thought this would work, but I get a warning. Is there another way to set a copy of an existing sheet to a variable?

    Thank you in advance
    Last edited by eclapt; 11-09-2009 at 11:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1