I know how to reference the value of a cell but is there a way o reference a
cells format?
Gord Dibben - 29 Dec 2007 19:33 GMT
Provide more details about what you wany to achieve, please.
There are ways to ascertain the formatting of a cell but generally would require
VBA
Gord Dibben MS Excel MVP
>I know how to reference the value of a cell but is there a way o reference a
>cells format?
Ron Rosenfeld - 29 Dec 2007 20:41 GMT
>I know how to reference the value of a cell but is there a way o reference a
>cells format?
In VBA, you can access the numberformat property.
As a worksheet function, you can access SOME (not ALL) information using the
CELL worksheet function (see HELP for that).
--ron