Offset of active cell

R

RichardGarfield

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

Stefi

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

Regards,
Stefi

„RichardGarfield†ezt írta:
 
R

RichardGarfield

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
 
S

Stefi

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:
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„RichardGarfield†ezt írta:
 
Top