+ Reply to Thread
Results 1 to 4 of 4

Cell References instead of Copy and Paste

  1. 04-01-2020, 05:26 PM #1
    excelhelp31120
    excelhelp31120 is offline
    Registered User
    Join Date
    03-11-2020
    Location
    Bloomington
    MS-Off Ver
    2018
    Posts
    22

    Question Cell References instead of Copy and Paste

    Hi all!

    I would like some help modifying the VBA code that I have. Currently, my code copies and pastes cells based on a certain criteria. However, now I would prefer it places a reference to the cell instead of copying and pasting.

    Takes information from here:
    pic1.png

    Puts in cell references:
    pic2.png

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-01-2020, 05:56 PM #2
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,938

    Re: Cell References instead of Copy and Paste

    To paste a link, just change the four lines where you place the values, from this

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Of course, do that for all four.
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
  3. 04-01-2020, 06:04 PM #3
    excelhelp31120
    excelhelp31120 is offline
    Registered User
    Join Date
    03-11-2020
    Location
    Bloomington
    MS-Off Ver
    2018
    Posts
    22

    Re: Cell References instead of Copy and Paste

    Thanks Bernie! That change worked like a charm!
    Reply With QuoteRegister To Reply
  4. 04-01-2020, 06:08 PM #4
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,938

    Re: Cell References instead of Copy and Paste

    And it saved me from trying to figure out the rest of the code!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy paste without incrementing - can't use absolute references
    By loulite in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2014, 05:21 PM
  2. [SOLVED] Copy and paste formulas without changing cell references
    By davidx in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-20-2013, 03:34 PM
  3. Copy and Paste Macro that will not effect cell references
    By glide2131 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2013, 07:26 PM
  4. [SOLVED] Copy / Paste without cell references changing.
    By Big Rick in forum Excel General
    Replies: 6
    Last Post: 05-08-2012, 03:15 PM
  5. Copy paste without references
    By vamshi57 in forum Excel General
    Replies: 2
    Last Post: 01-23-2011, 06:26 PM
  6. trying to copy and paste without cell references changing.
    By kxlxl in forum Excel General
    Replies: 3
    Last Post: 10-20-2006, 03:33 PM
  7. copy/Paste references other worksheet
    By Ivano in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2006, 08:15 PM
  8. Copy/Paste without changing location references
    By Tom in forum Excel General
    Replies: 3
    Last Post: 03-31-2005, 09:06 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1