Make Copy code easier

Hallo,
I use a Line that will copy information frome one sheet to another.
But there is Little delay in it ...can that be the vault of the code??
is there easy way to make my code easy or compacter?

Please Login or Register  to view this content.

Instead of:

Please Login or Register  to view this content.

This is usually quicker

Please Login or Register  to view this content.

Okey thank you.. i can use that now for more of my lines

is there a way to set a rang with out the number.... Example. .Range("G2:G") that it wil go on?

You would normally do something like:

Please Login or Register  to view this content.

to define a range that goes to the last used cell in a column.