Thread: getting a number format from a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert Robert is offline
external usenet poster
  
Posts: 193
Default getting a number format from a cell
str = Selection.Cells.NumberFormat

"Mike" wrote:

How do I get the number format from a given cell?

Range("E8").Select
str = Selection.NumberFormat

Thanks
Mike
Reply With QuoteReply With Quote