Thread: Get cell's number format category in VBA?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
dyowee dyowee is offline
external usenet poster
  
Posts: 7
Default Get cell's number format category in VBA?
This returns the actual number format, not the category, like 'General',
'Percentage', 'Currency', etc...

"Gary''s Student" wrote:

Sub whatformat()
MsgBox (ActiveCell.NumberFormat)
End Sub

--
Gary''s Student - gsnu200785
Reply With QuoteReply With Quote