How To: Use Cell("Format") to return MMMM YYYY instead of D3
Grüezi Tom
Tom Ogilvy schrieb am 18.05.2004
it might be important to note that if you copy a cell using this formula and
paste it on another sheet, in xl2000 and earlier, this will cause a general
protection fault, excel will close and you will loose any changes to your
workbook.
Thanks for upgrading my knowledge :-)
I believe xl2002 and possibly xl2003 are more tolerant.
It may be that SP3 fixed this problem - Excel refuses to paste this
'macro-formula', but it stays alive.
--
Regards
Thomas Ramel
- MVP for Microsoft-Excel -
[Win XP Pro SP-1 / xl2000 SP-3]
|