| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Date Format Cell Check
Hi,
I'm trying to check cells for Date format or not, but the code below isn't working properly. Despite confirming the Date format in the cells being checked, my code isn't running the command (ActiveCell.Offset(1, 0).Activate Instead, it's branching to the Else command, which I do not want. This seems simple, can someone help? If ActiveCell.NumberFormat = "Date" Then ActiveCell.Offset(1, 0).Activate Else ActiveCell.Select Selection.Cut ActiveCell.Offset(-1, 1).Activate ActiveSheet.Paste ActiveCell.Offset(1, -1).Activate End If Thanks! Kim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format with error & date check | Excel Worksheet Functions | |||
| How to check date format in display cell value | Excel Programming | |||
| Check data item is date not text format | Excel Programming | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Change text to date and check against date in cell | Excel Programming | |||
Threaded Mode
