Cutting, copying, and pasting my selection

A

andycharger

Hi

In my excel document, I need to highlight my used cells, copy the
cells, Move to cell DV1 and paste them.

Can anyone help me?
 
T

Tom Ogilvy

Range("A1").CurrentRegion.Copy Destination:=Range("DV1")
' Optional to highlight
Range("A1").CurrentRegion.Select

--
Regards,
Tom Ogilvy

andycharger said:
Hi

In my excel document, I need to highlight my used cells, copy the
cells, Move to cell DV1 and paste them.

Can anyone help me?
Click to expand...
creating financial statements
 
Top