+ Reply to Thread
Results 1 to 3 of 3

Copy Data and paste it in new sheet and save new sheet as value of cell a2

  1. #1
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Copy Data and paste it in new sheet and save new sheet as value of cell a2

    Dear Experts,

    I am trying to copy few lines of data (Filtered) from an existing file and paste it in new worksheet. After this I want to save the worksheet as value in Range(“a2”) of the new sheet . The code I am using is

    Please Login or Register  to view this content.
    This is saving the workbook with the value of original sheets range(“A2”) not with new sheets value in range(“A2”). Please advise.
    Best Regards/VKS
    Last edited by VKS; 07-03-2013 at 08:55 AM.

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

    Re: Copy Data and paste it in new sheet and save new sheet as value of cell a2

    You need to reference it with the name of the new sheet. If the new sheet is the active sheet.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Copy Data and paste it in new sheet and save new sheet as value of cell a2

    Thanks a lot AB. As always you have been a great help.

+ 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