Link to home
Create AccountLog in
Avatar of upobDaPlaya
upobDaPlaya

asked on

How to skip cells with a non-date value in a loop

I am via VBA looping thru row 1 Cells(1,5).Select and testing each cell to determine if it is a weekend.  If it is a weekend I am deleting the column.  My problem is if it hits a cell that has a non date value I get an error, otherwise the macro works great.

How do I test a cell to determine if a date value is found ?
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Can you show your code?
Avatar of upobDaPlaya
upobDaPlaya

ASKER

Thanks. Perfect !