🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.windows.ms
Article #11059

An Excel question.

#11059
From: cvemuri
Date: Sat, 20 Apr 1991 17:11
13 lines
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!cvemuri

Show 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