LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default Identifying Date Cells

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identifying quarter to which a date belongs? harsh_njoy Excel Discussion (Misc queries) 3 July 25th 08 09:47 AM
Identifying adjacent cells daddioja Excel Worksheet Functions 5 June 2nd 06 08:56 PM
Identifying #N/A cells Lee Harris Excel Worksheet Functions 1 November 18th 05 02:57 AM
Identifying Date Overlaps Tremain Excel Discussion (Misc queries) 1 May 10th 05 01:58 AM
Identifying and deleting all but the first and last cells for certain date Mark Kunkel Excel Programming 0 January 8th 04 06:44 PM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"