+ Reply to Thread
Results 1 to 5 of 5

Clear Contents of a cell if contents = 1/0/00

  1. 02-03-2015, 05:06 PM #1
    superiorsvc
    superiorsvc is offline
    Registered User
    Join Date
    02-03-2015
    Location
    Wichita, KS
    MS-Off Ver
    Microsoft Office 2011 Mac Version
    Posts
    3

    Clear Contents of a cell if contents = 1/0/00

    In Column B if the cell contains "1/0/00" I want the contents to clear.
    Reply With QuoteRegister To Reply
  2. 02-03-2015, 05:28 PM #2
    Mad-Mizer
    Mad-Mizer is offline
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Canada Eh
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Clear Contents of a cell if contents = 1/0/00

    Perhaps: 
    Please Login or Register  to view this content.
    Click the * to give Rep to a post you like.
    Reply With QuoteRegister To Reply
  3. 02-03-2015, 05:30 PM #3
    superiorsvc
    superiorsvc is offline
    Registered User
    Join Date
    02-03-2015
    Location
    Wichita, KS
    MS-Off Ver
    Microsoft Office 2011 Mac Version
    Posts
    3

    Re: Clear Contents of a cell if contents = 1/0/00

    It said Type mismatch?
    Reply With QuoteRegister To Reply
  4. 02-03-2015, 05:37 PM #4
    superiorsvc
    superiorsvc is offline
    Registered User
    Join Date
    02-03-2015
    Location
    Wichita, KS
    MS-Off Ver
    Microsoft Office 2011 Mac Version
    Posts
    3

    Re: Clear Contents of a cell if contents = 1/0/00

    When I ran the macros it said "Type Mismatch" any suggestions?
    Reply With QuoteRegister To Reply
  5. 02-03-2015, 06:25 PM #5
    bstier
    bstier is offline
    Registered User
    Join Date
    02-08-2013
    Location
    Louisiana, USA
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Clear Contents of a cell if contents = 1/0/00

    Try This, I just tweeked the previous posters code
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Clear contents based on contents of another cell
    By Katrina DTE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2013, 02:44 PM
  2. Clear contents in one cell when contents of another cell are deleted
    By rlbush2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2012, 10:29 PM
  3. Clear row contents and copy row contents.
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-19-2011, 01:08 PM
  4. Copy list contents down, then clear contents
    By hektisk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2011, 04:34 PM
  5. Clear sheet contents but retain Clipboard contents
    By nebb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2007, 01:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1