ws.copy pastespecial

[Vanda_a]

Dear all

Could somebody teach me how to deal with this 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

 

[AlphaFrog]

Try this...

WS.Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
ActiveSheet.UsedRange.Value = ActiveSheet.UsedRange.Value

 

[Vanda_a]

Try this...

WS.Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
ActiveSheet.UsedRange.Value = ActiveSheet.UsedRange.Value

Cool. Thank you very much.

Could you explain me how UsedRange.Value work please?