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-容x
------------------------------------------------------------------------
T-容x's Profile:
http://www.excelforum.com/member.php...o&userid=26572
View this thread:
http://www.excelforum.com/showthread...hreadid=400681