View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Offset of active cell

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?