| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
odd behavior when referencing a cell on another sheet
I'm using XL 2003. When I try to create a formula which references a cell on
another sheet, if that cell is near a cell with a comment, I can't select the cell unless the comment is hidden. The comment itself doesn't obscure the cell. Anyone else see this behavior? -- Brevity is the soul of wit. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
odd behavior when referencing a cell on another sheet
Dave F wrote:
I'm using XL 2003. When I try to create a formula which references a cell on another sheet, if that cell is near a cell with a comment, I can't select the cell unless the comment is hidden. The comment itself doesn't obscure the cell. Anyone else see this behavior? -- Brevity is the soul of wit. Hi Dave, I had a vague memory of this problem, so I did a quick search in this forum and found... Comment BUG- selecting cells on other worksheets which appeared March 6 this year. Only solution offered was turn off comments. Ken Johnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
odd behavior when referencing a cell on another sheet
Interesting, thanks.
-- Brevity is the soul of wit. "Ken Johnson" wrote: Dave F wrote: I'm using XL 2003. When I try to create a formula which references a cell on another sheet, if that cell is near a cell with a comment, I can't select the cell unless the comment is hidden. The comment itself doesn't obscure the cell. Anyone else see this behavior? -- Brevity is the soul of wit. Hi Dave, I had a vague memory of this problem, so I did a quick search in this forum and found... Comment BUG- selecting cells on other worksheets which appeared March 6 this year. Only solution offered was turn off comments. Ken Johnson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
odd behavior when referencing a cell on another sheet
You're welcome Dave. Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
| referencing Excel sheet name in cell | Excel Worksheet Functions | |||
Linear Mode
