+ Reply to Thread
Results 1 to 2 of 2

Do Until you find a cell with a value in date format

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    77

    Do Until you find a cell with a value in date format

    Hi,

    I'm really new to VBA, and I was wondering if there was a way to loop a variable until it reaches a cell that is in date format. The problem is I have a column of dates that I want to copy, but i'm not always sure what row the dates will start on. I can't do End.xldown because occasionally there will be a formula or number in a cell above where the dates start. So I was hoping to find a way to determine the first cell that is in date format and go from there instead. Is this a possibility?

    Thanks!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Do Until you find a cell with a value in date format

    IsDate(someCell.value) will tell you if a cell contains a number formatted as a date.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro changing date format when doing find and replace
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-22-2013, 08:16 PM
  2. Replies: 1
    Last Post: 11-01-2012, 10:37 AM
  3. find method fails to find custom format date
    By yot68 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2012, 06:28 PM
  4. Replies: 2
    Last Post: 10-02-2010, 04:41 AM
  5. Find and replace the date format in Word file
    By vinwin06 in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2010, 09:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1