PDA

View Full Version : xl Cell Properties



DerbyNeal
05-16-2006, 04:19 AM
Hi,
Does anyone know where I can find a comprehensive list of '.Cells()' properties that I can Test for/Apply to Excel Cells?

i.e.
Cells(x,y).NumberFormat

I want to set Conditional Formatting using VBA,
to test for:
Data Type (Character, Integer, Date, Decimal, Logical)
Field Length (x(50), 999, 99/99/9999, 999.99, Yes/No)

from an imported file.

Thanks in advance,

Neal

Bob Phillips
05-16-2006, 04:33 AM
Cross-posting, also at Ozgrid (http://www.ozgrid.com/forum/showthread.php?t=50805)