How do I change the code below so that all used rows are copied, not the static range?
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif] Range("A1:F20").Select
Selection.Copy
My data could end in row 31 or 11, which is why I need a dynamic range.
[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif] Range("A1:F20").Select
Selection.Copy
My data could end in row 31 or 11, which is why I need a dynamic range.
[/FONT]