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
Angelo
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
https://www.rondebruin.nl/win/s3/win003.htm
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
Angelo
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
https://www.rondebruin.nl/win/s3/win003.htm