| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset of active cell
Help please. How do I find the offset of the active cell from the top left
cell in a named range? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Offset of active cell
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Offset of active cell
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Offset of active cell
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Offset of active cell
You are welcome! Thanks for the feedback!
Stefi €˛RichardGarfield€¯ ezt Ć*rta: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move from active cell offset in macro | Excel Discussion (Misc queries) | |||
| run macro although blinking cursor is active in an active cell | Excel Programming | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Programming | |||
| active offset | Excel Programming | |||
Linear Mode
