|
Subject:
|
xl Cell Properties
|
|
Posted By:
|
Neal
|
Post Date:
|
5/16/2006 6:19:01 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
A Northern Soul
|
|
