Hi Anita

I think you need something like
set dd - activecell.currentregion

--
Regards

Roger Govier


"anita" wrote in message
ps.com...
Hi,

I would like to have a macro which picks up my selected range in a
workbook, similair to the activecell. So when I select a range in my
workbook, it will be set as range in my macro.


I've tried active.range but this doens't work (something like this:
Set
dd = Active.Range). I can't find it in the list properties/methods in
vba.
Could somebody help me?
Thanks in advance.