Can one test for Excel cell format patterns?
 

Is there a method to test cells to determine their format patterns?

Can one test for Excel cell format patterns?
 

?Range("a1").NumberFormat
General

NickHK

"genie56" wrote in message
...
Is there a method to test cells to determine their format patterns?

Can one test for Excel cell format patterns?
 

On Thu, 17 May 2007 17:48:01 -0700, genie56
wrote:

Is there a method to test cells to determine their format patterns?

Yes, and which you use depends on what property you are looking to test.

..borders
..color
..numberformat

are just a few.




--ron