ExcelBanter - find format of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - find format of cell (https://www.excelbanter.com/excel-programming/392084-find-format-cell.html)

dan

find format of cell

is it possible to find the format of an empty cell.
If it was not empty I would have used isnumeric, isdate...

Many thanks

Dan

Kevin Beckham[_3_]

find format of cell

Use
ActiveCell.NumberFormat to get its string representation

Kevin Beckham

"Dan" wrote:

is it possible to find the format of an empty cell.
If it was not empty I would have used isnumeric, isdate...

Many thanks

Dan

All times are GMT +1. The time now is 12:43 PM.