Many thanks, Stefi

With your help, I've solved it.

Best wishes

Richard

"Stefi" wrote:

You misunderstood my post, it has nothing to do with RowRange and ColumnRange.
Subtract range("rngname").Row from activecell.Row for row offset and
subtract range("rngname").Column from activecell.Column for Column offset:

activecell.Row - range("rngname").Row
activecell.Column - range("rngname").Column

Regards,
Stefi

€žRichardGarfield€� ezt Ã*rta:

Hi Stefi

Thanks for the suggestion. It seems that RowRange and ColumnRange only apply
to Pivot Tables. I can't get your code to work for a worksheet range.

Best wishes

Richard

"Stefi" wrote:

Maybe you mean
activecell.Row-range("rngname").Row
activecell.Column-range("rngname").Column

Regards,
Stefi

€žRichardGarfield€� ezt Ã*rta:

Help please. How do I find the offset of the active cell from the top left
cell in a named range?