Return column format in message box

[Kellogg]

Dear Great Minds of Excel,

Is there a way to return the format of a column, using vba, via a message box. I have tried GetFormat() but no luck.


Thanks in advance.



/s/

craig

 

[Joe4]

How about something like:

MsgBox Range("A1").NumberFormat

 

[Kellogg]

Joe4,


Thanks a lot.

I did it this way instead.

ColFmt01 = Worksheets("WhichPage").Columns(1).NumberFormat

This allowed me to later use vba to format a column in a vba generated report. Yours helped push me in the right direction. Now on to the next challenge.





/s/


Craig