Amazing... something hidden in cells...
 

Hi all...

ran into an amazing thing... there is an application that opens a
workbook/sheet in excel, and adds a couple tools in my tool bar for purposes
of inporting data from excel... back into the application.

On the "blank" worksheet it opens... there are 4 cells that if I delete them
or move them, the worksheed "breaks" (meaning, that it fails to import the
data).

Problem is: The cells are blank. There is nothing in them. I can even add
garbage text into them... and the import works fine. But cut the cells, or
delete them... then the whole thing breaks! Paste them back... all is ok.

The cells are not locked... there are no formulas... nothing in them that I
can see.

Can one associate macro code directly to a cell?

What the heck could be hiding in these cells? How to see their contents?

Something that can be cut and pasted is inside these cells... but it's
totally invisible to me what it is.

Any ideas?

Thx

MP

Amazing... something hidden in cells...
 

Not sure, but a range can have an ID value
Range("A1").ID=123

This is meant for use with HTML, but can be used anyway.

NickHK

"rci" wrote in message
...
Hi all...

ran into an amazing thing... there is an application that opens a
workbook/sheet in excel, and adds a couple tools in my tool bar for
purposes
of inporting data from excel... back into the application.

On the "blank" worksheet it opens... there are 4 cells that if I delete
them
or move them, the worksheed "breaks" (meaning, that it fails to import the
data).

Problem is: The cells are blank. There is nothing in them. I can even
add
garbage text into them... and the import works fine. But cut the cells,
or
delete them... then the whole thing breaks! Paste them back... all is ok.

The cells are not locked... there are no formulas... nothing in them that
I
can see.

Can one associate macro code directly to a cell?

What the heck could be hiding in these cells? How to see their contents?

Something that can be cut and pasted is inside these cells... but it's
totally invisible to me what it is.

Any ideas?

Thx

MP

Amazing... something hidden in cells...
 

Good thought, Nick... but the ID was blank. This is so odd! There really
is something special about these cells... but I just can't see what it is...
anyone else have some idea?


NickHK wrote:
: Not sure, but a range can have an ID value
: Range("A1").ID=123

: This is meant for use with HTML, but can be used anyway.

: NickHK

: "rci" wrote in message
: ...
: Hi all...
:
: ran into an amazing thing... there is an application that opens a
: workbook/sheet in excel, and adds a couple tools in my tool bar for
: purposes
: of inporting data from excel... back into the application.
:
: On the "blank" worksheet it opens... there are 4 cells that if I delete
: them
: or move them, the worksheed "breaks" (meaning, that it fails to import the
: data).
:
: Problem is: The cells are blank. There is nothing in them. I can even
: add
: garbage text into them... and the import works fine. But cut the cells,
: or
: delete them... then the whole thing breaks! Paste them back... all is ok.
:
: The cells are not locked... there are no formulas... nothing in them that
: I
: can see.
:
: Can one associate macro code directly to a cell?
:
: What the heck could be hiding in these cells? How to see their contents?
:
: Something that can be cut and pasted is inside these cells... but it's
: totally invisible to me what it is.
:
: Any ideas?
:
: Thx
:
: MP
: