Determine a cell's format and type

[ihf]

How do I determine a cell's type (e.g., numeric or string or formula) and if numeric, the format (e.g., currency, general, scientific) including the number of decimal places. Is there a function that returns the object's properties? Must I use isnumeric, isformula, and so on or is there one function that returns this information?

[rylo]

Hi

There is an old excel 4 macro function get.cell that can return a heap of info about a cell.

Have a look here to find out how to use it, and what each of the arguments are showing. Argument 48 will show if it is a formula for instance....

HTH

rylo

[stanleydgromjr]

ihf,

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Press and hold down the 'ALT' key, and press the 'F11' key.

Insert a Module in your VBAProject, Microsoft Excel Objects

Copy the below code, and paste it into the Module1.

Please Login or Register  to view this content.

Have a great day,
Stan

[ihf]

Thanks very much!