Re: Ciruclar Reference

Hi

Usually Excel gives you the cell reference in the status bar, and puts a
blue dot in the offending cell!

Andy.

"Peter Marshall" <peter.marshall@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uPfJjz%23$FHA.1288@xxxxxxxxxxxxxxxxxxxxxxx
>A simple question: when your worksheet has a circular reference, how do
>you find it?
>
> --
> Peter Marshall
> Manager Information Services
> Ohio Coatings Company
>


.

Relevant Pages

  • 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 ...
    (microsoft.public.excel.misc)
  • 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 ...
    (microsoft.public.excel)
  • 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, ...
    (microsoft.public.excel.worksheet.functions)
  • 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. ...
    (microsoft.public.excel.misc)
  • 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? ...
    (microsoft.public.excel.misc)