+ Reply to Thread
Results 1 to 4 of 4

Copy cells to new Sheet and Save Sheet

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    US
    MS-Off Ver
    2013
    Posts
    67

    Copy cells to new Sheet and Save Sheet

    So I want my command to copy Cells starting in (50,2) to the new sheet starting in (4,1). Here is what I have however it errors, I am trying to save only Sheet0 and not the entire workbook. I googled the problem and this is what others say to do to save just a single sheet.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by DadaaP; 06-25-2013 at 10:29 AM.

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: Copy cells to new Sheet and Save Sheet

    This code will not save the new sheet, but it creates it.
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Copy cells to new Sheet and Save Sheet

    Use Pastespecial not paste:
    Please Login or Register  to view this content.
    I'd probably not copy them individually either, something like this should do the same thing:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-30-2013
    Location
    US
    MS-Off Ver
    2013
    Posts
    67

    Re: Copy cells to new Sheet and Save Sheet

    I already have the sheet created in my excel workbook. I just need it to populate the sheet with the loop as posted earlier. However right now its erroring on object, on line ActiveSheet.Cells(PasteCell,1).Paste

+ Reply to Thread

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