Article View: comp.windows.ms
Article #11059An Excel question.
From: cvemuri
Date: Sat, 20 Apr 1991 17:11
Date: Sat, 20 Apr 1991 17:11
13 lines
1195 bytes
1195 bytes
I am developing an application in Excel which automatically identifies all the precedents of cell. Then it will change the colors of those cells and if possible will put arrows from precedents to current cell. I know Excel already provides some thing like this in its Show info command. My question is, is there any macro funtion in Excel that takes a cell and returns all its precedents. I searched the excel function reference manual, but couldn't find one. Can any one tell me how to do this. If it is not readyly available can you suggest a way that I can write a macro to do this function? I am using Excel 3.0. Thanks in advance. Sarat
Technical Details
Message-ID:
<1991Apr20.171144.7276@hubcap.clemson.edu>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!emory!hubcap!chinook.eng.clemson.edu!cvemuriShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!emory!hubcap!chinook.eng.clemson.edu!cvemuri From: cvemuri@chinook.eng.clemson.edu Newsgroups: comp.windows.ms Subject: An Excel question. Keywords: SHOW.INFO Message-ID: <1991Apr20.171144.7276@hubcap.clemson.edu> Date: 20 Apr 91 17:11:44 GMT Sender: news@hubcap.clemson.edu (news) Reply-To: cvemuri@chinook.eng.clemson.edu Followup-To: comp.windows.ms Organization: Clemson University Engineering Department Lines: 13