LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default how to find cells that refer to data in other cells in excel

Lets say I have some number in cell A1. lets say, cell x4 and ab200 have
forumalas that use the number in cell A1.

If I didnt know what cell used data in cell A1 to determine its value, is
there anyway to find which cells in an excel file refer to a cell to
determine its value. I am looking for a fuction say "find_cell_reference"
which takes in the argument of a cell for which references are to be found.
so i would type something like:

find_cell_reference(A1)

and it will return something like "x4 and ab200"

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Using cells to refer to worksheets Rup1776 Excel Worksheet Functions 1 September 27th 06 09:36 AM
Why do some Excel cells refer to e-mail? Fred in Keswick Excel Worksheet Functions 1 February 28th 06 10:09 PM
How to find multiple cells/replace whole cells w/data dcurylo Excel Discussion (Misc queries) 2 November 30th 05 08:06 PM
Excel should let me use formulas that refer to other cells w/ form Chenopod Excel Worksheet Functions 7 May 31st 05 04:21 PM
To get a lot of charts that refer to different cells Anderson Lee Charts and Charting in Excel 1 December 28th 04 02:35 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"