Cell References instead of Copy and Paste

**excelhelp31120** · 04-01-2020, 05:26 PM

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.

**Bernie Deitrick** · 04-01-2020, 05:56 PM

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.

**excelhelp31120** · 04-01-2020, 06:04 PM

Thanks Bernie! That change worked like a charm!

**Bernie Deitrick** · 04-01-2020, 06:08 PM

And it saved me from trying to figure out the rest of the code!

Cell References instead of Copy and Paste

LinkBack

Thread Tools

Rate This Thread

Display

Cell References instead of Copy and Paste

Re: Cell References instead of Copy and Paste

Re: Cell References instead of Copy and Paste

Re: Cell References instead of Copy and Paste

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy paste without incrementing - can't use absolute references

[SOLVED] Copy and paste formulas without changing cell references

Copy and Paste Macro that will not effect cell references

[SOLVED] Copy / Paste without cell references changing.

Copy paste without references

trying to copy and paste without cell references changing.

[SOLVED] copy/Paste references other worksheet

[SOLVED] Copy/Paste without changing location references

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions