Assinging Range to mulitple selected cells?

If I use a range variable "rSelect" I can easily assign it to the
activecell in the active worksheet using...

rSelect = ActiveCell

But if the user selects multiple cells how do I assign rSelect...it
wont let me do it.

I have seen another macro that uses...

Selection.Copy

but I would like to manipulate those cells using a range before I paste
them somewhere else.

Am I right off track (usually the case!) or is there an obvious way to
do this?

Thanks.

Greg.


---
Message posted from http://www.ExcelForum.com/

One way:

Dim rSelect As Range
Set rSelect = Selection

If you want to be sure the selection is a range:

Dim rSelect As Range
If TypeName(Selection) = "Range" Then
Set rSelect = Selection
Else
MsgBox "No Range Selected"
End If


In article ,
gregga wrote:

If I use a range variable "rSelect" I can easily assign it to the
activecell in the active worksheet using...

rSelect = ActiveCell

But if the user selects multiple cells how do I assign rSelect...it
wont let me do it.

I have seen another macro that uses...

Selection.Copy

but I would like to manipulate those cells using a range before I paste
them somewhere else.

Am I right off track (usually the case!) or is there an obvious way to
do this?

Thanks for your help.


---
Message posted from http://www.ExcelForum.com/