Results 1 to 3 of 3

Thread: Copy & paste value from / to worksheets

  1. #1
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,580
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Copy & paste value from / to worksheets

    Hi,
    Long story short.

    A code used say 4 months ago has now raised a problem so i need to fix 4 months of worksheets.

    Ive now sorted out the worksheet & all is ok.
    My task now is to copy the values from one worksheet to another worksheet.

    Sounds easy but sometimes i see a message about source etc etc.
    I also just wish to copy values only and not formulas etc.

    The worksheet it will be pasted to will have formulas in cells but my only other option is to type every value out.

    Can you advise how i do this correctly without the source message when i try to paste

    Thanks
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

  2. #2
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,230
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Copy & paste value from / to worksheets

    Would you like to post some info like the ranges that you are pasting from and to and the names of the worksheets? also can you elaborate on what you mean by "The worksheet it will be pasted to will have formulas in cells" are you overwriting the formulas?

    Sounds easy but sometimes i see a message about source etc etc
    Can you post the exact message that you are getting and the code that you are using?
    Last edited by MARK858; Oct 5th, 2019 at 05:20 PM.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #3
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,580
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy & paste value from / to worksheets

    Hi,
    Thanks but i managed to do it all last night
    Have a nice day
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

Some videos you may like

User Tag List

Tags for this Thread

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
  •