Active range/selection?
Sorry
That "-" was meant to be an "="
set dd = activecell.currentregion
--
Regards
Roger Govier
"Roger Govier" wrote in message
...
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.
|