+ Reply to Thread
Results 1 to 6 of 6

Copy Func. using Macros

  1. #1
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    13

    Copy Func. using Macros

    Greetings,

    I have issues with using the copy function with macro since i have "=" sign in my cell that needs to copied to the next sheet.

    Please help.

    thank you.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Copy Func. using Macros

    You have not explained your problem very well.
    Please provide
    - your code (enclosed in code tags) and
    - an example of what the code currently does and
    - what you would like it to do.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Copy Func. using Macros

    I would like to copy data from a cell on WORKSHEET A to another cell on a WORKSHEET B.

    Cell O3 his a reference from Cell J9.

    1.jpg
    This is my code:
    Range("O3").Copy Sheets("WORKSHEET B").Range("A10000").End(xlUp).Offset(1, 0)

    this is the result:
    #REF

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Copy Func. using Macros

    Your code is copying cell O3 with formula "=J3" and pasting it to column A (in another sheet)

    Try that manually (within the same sheet) and you get the same result because Excel is re-referencing the formula
    -copy O3 to F3 and formula is re-referenced and becomes "=A3"
    -copy O3 to anywhere in columns A:E and #REF is the result

    To paste the value of cell O3:
    Please Login or Register  to view this content.
    To paste the value and cell formatting of cell O3:
    Please Login or Register  to view this content.
    To attribute the value
    Please Login or Register  to view this content.
    To paste the formula (=J3) without re-referencing
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Copy Func. using Macros

    thank you very much. that was very helpful

  6. #6
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Copy Func. using Macros

    You are welcome
    Thanks for marking the thread as solved and for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy & Pasting Macros with Macros
    By enfinity86 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2012, 12:14 PM
  2. using address func with 3d sum
    By mennojim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-25-2010, 11:58 AM
  3. Func Search
    By Shiftlord in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-03-2009, 12:33 PM
  4. Same format & func. for 07 worksheet
    By Walley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2007, 10:52 PM
  5. How 2 sum the abs values of several cells w 1 func in XL.
    By bob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2006, 04:30 PM
  6. [SOLVED] How 2 sum the abs values of several cells w 1 func in XL.
    By bob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2006, 04:25 PM
  7. [SOLVED] Help pls! Max func to display value of different cell?
    By Impakt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2005, 12:06 AM
  8. is there this func?
    By dino-new in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2005, 10:11 PM

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