Dear all
Could somebody teach me how to deal with this code
I had it from my an other post and it is too old post to reply.
I have it working for me so well but it is abit annoying. Whenever I got links(Ex: Sheet2 A1 = Sheet1 B1), it pastes the link(=C:\.........Sheet1!B1) rather than the value. how to get the value only?
Willing to give more detail
Thank you very much
Could somebody teach me how to deal with this code
Code:
WS.Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
I had it from my an other post and it is too old post to reply.
I have it working for me so well but it is abit annoying. Whenever I got links(Ex: Sheet2 A1 = Sheet1 B1), it pastes the link(=C:\.........Sheet1!B1) rather than the value. how to get the value only?
Willing to give more detail
Thank you very much