Identifying Date Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Back
Top