Cutting, copying, and pasting my selection

  • Thread starter Thread starter andycharger
  • Start date Start date
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?
 
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?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top