Re: Ciruclar Reference
- From: <Andy>
- Date: Tue, 13 Dec 2005 14:07:37 -0000
Usually Excel gives you the cell reference in the status bar, and puts a
blue dot in the offending cell!
"Peter Marshall" <peter.marshall@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>A simple question: when your worksheet has a circular reference, how do
>you find it?
> Peter Marshall
> Manager Information Services
> Ohio Coatings Company
- Re: Value used in a Paste Link to remain constant during a sort
... However, when we sort the data in Worksheet A, the absolute cell reference ... this is the "normal" behavior when you sort data-lists ...
- Re: excel tables
... Using a single cell reference does come up with the message ... type a straightforward range address on another sheet or in another ... UNIT COST SCREEN GRILLES ... Worksheet 2 - In this worksheet I want to be able to pick from ...
- Re: Sum delimited values in cell
... The reason I asked was because as coded it was a bit specific, ... I would actually put the delimiter value in to another cell, say B1, and use ... a cell reference in the formula rather than the delimiter, ... >> Andy, ...
- Re: Can I add to a cell reference?
... to get the last entry in a column use one of the following formulas: ... Frank Kabel ... On one worksheet I have new data being filled in> each month. ... I cannot seem> to "add" to a cell reference. ...
- Re: Display
... Jacob Skaria wrote: ... Include the cell reference in your formula.ORTry the below for sheet ... How do I show the worksheet name in a cell? ...