turning selection into a range
 

A few cells are selected and my macro is run, how do i define a range
out of the selection. in other words the range should be the cells that
are selected. how?

Thanx


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=400681

turning selection into a range
 

The 'Selection' property already returns a Range of selected cells...
If you want to assign the selected cells to a Range variable, you can
do this:

Dim YourRange As Range
Set YourRange = Selection


schoujar Wrote:
A few cells are selected and my macro is run, how do i define a range
out of the selection. in other words the range should be the cells that
are selected. how?

Thanx


--
T-®ex
------------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572
View this thread: http://www.excelforum.com/showthread...hreadid=400681