Grüezi Kevin

Kevin McCartney schrieb am 18.05.2004

I'm trying to get the format property of a of a cell with using macros
just using worksheet functions. When I use Cell("Format",A1) it returns
D3, but I need the MMMM YYYY custom format that I have placed on the
cell to be returned, any ideas how to get it?

There might be a possibility when you use xl4Macros in a defined name.

Insert -- Names -- Define -- Names in Workbook: 'Cellformat' -- Refers
to:

=GET.CELL(7;INDIRECT("RC(-1)";FALSE))

-- [Add] -- [OK]

When you like to see the format of A1, then:

B1 =Cellformat

'Cellformat' evaluates the cell left of where you use it in the table.

--
Mit freundlichen Grüssen

Thomas Ramel
- MVP für Microsoft-Excel -

[Win XP Pro SP-1 / xl2000 SP-3]