Forum Discussion
Copy-Paste as link but also with cell borders?
Hi! Attached is a sample file. I have written a macro that copies a subset of cells from the source sheet and pastes it into a new sheet as LINKED, enabling the new sheet to update if the source...
Untested, but should work :))
Insert_formatlink ()
Sheets ("Sheet1"). Range ("Area2"). EntireRow.Copy
Sheets ("Sheet1"). Range ("Area2"). EntireRow.Insert Shift: = xlDown, CopyOrigin: = _
xlFormatFromLeftOrAbove
Sheets ("Sheet1"). Range ("Area2"). Offset (-1) .EntireRow.ClearContents
End Sub
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
NikolinoDE - Thanks for your input, but that's not working for me. I need to paste as a link and with source cell formatting (underline or no underline).
Note that in my sample file that on the PASTE_LINKED sheet there are only 10 columns. They are sheet SOURCE_PAGE columns U through AD. These are the only columns I need to copy over.
Again, thanks fort the effort though!