pini35 wrote in message ...
If I'm right in what I think you want to do, you can try using:

*ActiveCell.NumberFormat*

this will give you the format of the current cell. For example a cell
that is formatted as Text will return the "@".

General cells will return "General".
Time and Date cells will return the time or date format you selected
etc.

You can format your cells, then run some code to record all the formats
you require.


Cheers pini35, that is exactly what I wanted.... just needed the right syntax.