turning selection into a range

[schoujar]

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]

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

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