Saturday, January 8, 2011

Function to check if cell value is date or not

Function checkdate(x As Date)

checkdate = IsDate(x)
End Function

it will return True if cell value is Date

No comments:

Post a Comment

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...