maybe...

dim myRng as range
with activecell
set myrng = .parent.range(.cells(.row,.column).address)
end with

But that seems very convoluted to me. Why can't you just use Activecell?

Caeres wrote:

I need to refer to the active cell using the Cells property (eg
Range.Cells(...)). How do I do this?

--

Dave Peterson