Cutting, copying, and pasting my selection
 

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?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

Cutting, copying, and pasting my selection
 

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

--
Regards,
Tom Ogilvy

"andycharger" wrote in message
...

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?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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