Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Can one test for Excel cell format patterns?

Is there a method to test cells to determine their format patterns?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,651
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Test on the format of a cell in a formula ? brunzeg New Users to Excel 1 November 13th 09 11:05 AM
format cells, patterns, in right hand mouse menu on excel 2007 willyhoops.com Excel Discussion (Misc queries) 1 February 5th 07 04:00 PM
Printing cell patterns in Excel Timothy Excel Discussion (Misc queries) 0 January 13th 06 05:29 PM
can I customize cell fill patterns in Excel? bghough Excel Discussion (Misc queries) 0 March 10th 05 06:09 PM
Excel cell patterns gisconsultant Excel Discussion (Misc queries) 0 February 21st 05 10:31 AM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"