How can a formula get the location of the cell it is placed in?

Posted to microsoft.public.excel.programming

Bernard[_4_] Bernard[_4_] is offline

external usenet poster

Posts: 1

How can a formula get the location of the cell it is placed in?

Hi-

Is there any way a formula can get the location of the cell it is placed
in? I need the row and column of the cell at recalculation time, not at the
time formula was entered, so ActiveCell won't do the job.

Thanks in advance for any help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
a formula that return the cell location in a range	danpt	Excel Discussion (Misc queries)	5	May 3rd 09 12:43 PM
Macro - save to current location vs excel default location	leezard	Excel Discussion (Misc queries)	0	October 28th 08 03:04 PM
How do you have a formula range be determined by the location ofanother cell?	Daniel[_3_]	Excel Worksheet Functions	2	February 8th 08 03:01 PM
Using Dynamic Cell Address As Formula Location	[email protected]	Excel Worksheet Functions	4	March 6th 07 06:37 AM
how to auto increment cell location within formula	Bill	Excel Worksheet Functions	3	February 16th 06 02:23 PM

All times are GMT +1. The time now is 04:26 PM.

Menu

About Us