![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
Please confirm the correct answer to the below question
cell reference in a formula is called? |
| Ads |
|
#2
|
|||
|
|||
|
I'm not sure what you are asking for. In a user defined function
in VBA, Application.Caller will return a Range reference to the cell which called the function. In a formula, ADDRESS(ROW(),COLUMN()) will return the address of the cell containing the function. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "???????????" > wrote in message ... > Please confirm the correct answer to the below question > > cell reference in a formula is called? |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I set a cell to "Empty" so that it does not display in a ch | Ian | Charts and Charting in Excel | 3 | January 7th 05 01:12 AM |
| how to cell reference a Chart title | Rasoul Khoshravan Azar | Charts and Charting in Excel | 2 | January 1st 05 05:00 PM |
| make a cell empty based on condition | mpierre | Charts and Charting in Excel | 2 | December 29th 04 01:01 PM |
| Using Name Label to try to define linked cell | John | Links and Linking in Excel | 5 | December 4th 04 09:12 AM |
| Transferring cell content between workbooks using cell references | Kiwi Mike | Excel Discussion (Misc queries) | 2 | November 27th 04 11:31 PM |