Select "numberformat cells" with autofilter ?

[bojzon]

In some columns I need to find if exist more then one number format. Is it possible to select cells and rows "with custom number format" using autofilter?

Any alternative for large xls tables? I tried with additional column with
ActiveCell.Value = Cell.Offset(0, -1).NumberFormat
with no success.

Thanks
Bojzon

 

[SkipVought]

Hi,

Add a column
[tt]
=CELL("format",A1)
[/tt]
Then filter on it.

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}