Hello.
I would like to offset a cell based on which current cell, row and column that currently is active.
How can I check which cell, row or column that is active?
/Anders
Hello.
I would like to offset a cell based on which current cell, row and column that currently is active.
How can I check which cell, row or column that is active?
/Anders
Look at the Name box. It continually display the active cell using the notation (A1 or R1C1) you have opted to use. The name box is located immediately to left of the formual bar and directly above the column header.How can I check which cell, row or column that is active?
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
That would of course work but I need to update a formula based on which cell I am currently pointing on.
Is there a function that collect the data from the current active cell?
If by "pointing on" you mean the cell which the mouse pointer is hovering over, then this would involve a great deal of complex programming.
If you mean the Excel cell pointer, then why does the name box not suffice to indicate the active cell?
You might try explaining more fully what you're seeking to accomplish.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks