Results 1 to 4 of 4

Macro to delete any rows in column ‘A’ which do not have a date in them

Threaded View

robertguy Macro to delete any rows in... 09-06-2011, 05:45 AM
Marcol Re: Macro to delete any rows... 09-06-2011, 06:02 AM
robertguy Re: Macro to delete any rows... 09-06-2011, 06:27 AM
robertguy Re: Macro to delete any rows... 09-15-2011, 07:26 AM
  1. 09-06-2011, 05:45 AM #1
    robertguy is offline
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    475

    Thumbs up Macro to delete any rows in column ‘A’ which do not have a date in them

    Hi.

    Can any please advise me of the macro code I need to check all cells in column ‘A’ for any cells that do not contain a date and then delete them N.B. the dates (to keep) will be in the format dd/mm/yy

    Any help would be greatly appreciated

    Many thanks in advance


    Rob

    N.B Excel version 2003
    Last edited by robertguy; 09-15-2011 at 07:27 AM. Reason: to mark as solved
    Rob
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1