Thread: Setting cell format based on format codes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hans Knudsen Hans Knudsen is offline
external usenet poster
  
Posts: 36
Default Setting cell format based on format codes
I have some format codes in G14:G36 like:
G14: #.##0..
G15: _(* #.##0_);_(* (#.##0);_(* "-"_);_(@_)
G16: "+45"## ## ## ##
etc.

and would like a macro that can take the format codes in G14:G36 and create
these formats in cells I14:I36.

Will someone help me?

Regards
Hans Knudsen


Reply With QuoteReply With Quote