Thread: How To: Use Cell("Format") to return MMMM YYYY instead of D3
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin McCartney[_2_] Kevin McCartney[_2_] is offline
external usenet poster
  
Posts: 32
Default How To: Use Cell("Format") to return MMMM YYYY instead of D3
Hi
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

TI
KM
Reply With QuoteReply With Quote