J Jeff Klein Dec 29, 2007 #1 I know how to reference the value of a cell but is there a way o reference a cells format?
G Gord Dibben Dec 29, 2007 #2 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
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
R Ron Rosenfeld Dec 29, 2007 #3 I know how to reference the value of a cell but is there a way o reference a cells format? Click to expand... 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
I know how to reference the value of a cell but is there a way o reference a cells format? Click to expand... 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
