Use range.copy_ destination:= ... instead of range.copy range.paste is not working. Help!

[Halil93]

Hi all,

i have tried to build a makro which replaces strings( sh.Cells(j, 4) -> list of 42 to words = find what ) in other strings ( sh.Range("A2", t) -> list of words where part f strings should be replaced ), with strings ( sh.Cells(j, 5) -> list of 42 words = replace with).

The issue i am having now is that when copying sh.Range("A2", t).Copy so a range in a column from the "A2" to the "last cell with value".
I would like to use the

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

But it is not working and saying " Compile Error _ expected expression "
Does somebody now what i do wrong and why it is not working?
Cheeers in advance .

Here is the code

Please Login or Register  to view this content.

[rorya]

It's one line:

Please Login or Register  to view this content.

[Halil93]

True, works fine. Thank you very much!