I don't have the help file on my machine, and it's been awhile since I've done this. How do I set the range property?

For example

Dim MyRange as Range

MyRange = Activecell.range

This doesn't work because it wants more parameters for the range property.

I also tried Range(activecell), but that didn't work either.

Thanks,

LauRa