Changing VBA code to paste values

May 9, 2017
Reaction score
Dear all
Newbie here. In relation to MS Excel I mostly get my code from the net which I manage quite well in cannibalizing for my purposes.
I am stuck on the code below as I can't figure how to change it so that it pastes just the values and not links. It's the bit after .Formula=.
If any kind person can help I would be very grateful.

Thanks in Advance


For Each myCell In Sh.Range("C3,C4,C6,C7,C8,C10,D13,D14,F13,F14,C34")
ColNum = ColNum + 1
Newsh.Cells(RwNum, ColNum).Formula = _
"='" & Sh.Name & "'!" & myCell.Address(False, False)
Next myCell

Link to complete code can be found here

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question