Identifying Date Cells

S

SuperJas

Hi

Is there a simple piece of code that can identify whether a cell is formatted as a date? I'd like to identify such cells in my worksheet and tell the macro to skip over these when processing

Many thanks in advance

SuperJas.
 
A

acw

SuperJa

Have a look at the CELL function. In the form CELL("format",a1) it will return a series of values in the range D1 - D9 for date formats

Ton

----- SuperJas wrote: ----

Hi

Is there a simple piece of code that can identify whether a cell is formatted as a date? I'd like to identify such cells in my worksheet and tell the macro to skip over these when processing

Many thanks in advance

SuperJas.
 
J

John Wilson

SuperJas,

Try the isdate function

From the immediate window:

?isdate(range("B10"))

Sub TestMe()
If isdate(range("B10") then
msgbox "It's a date"
else
msgbox "Not a date"
End If
End Sub

John




SuperJas said:
Hi,

Is there a simple piece of code that can identify whether a cell is
Click to expand...
formatted as a date? I'd like to identify such cells in my worksheet and
tell the macro to skip over these when processing.
 
Top