Hi , Can any one help with a macro script..

I created a range "range1" using allow user to modify range. Iam looking for a macro which edits the range1 as pre-selected.

Means, after selecting cells, when I run a macro, "range1" must be modified to selected range.

Would be a great help if some helps me with this..

thanks
var