View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Thomas Ramel Thomas Ramel is offline
external usenet poster
 
Posts: 70
Default 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]