+ Reply to Thread
Results 1 to 2 of 2

run-time error 13 with code - Clearing Contents of cells

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    19

    run-time error 13 with code - Clearing Contents of cells

    Currently I have a spreadsheet running that tells me if an Associate is choosen for the trip. When I clear contents on one cell I am fine but if I clear more than one cell at a time I get a run-time error 13. Is there any way to remove this error?



    Please Login or Register  to view this content.
    Last edited by Chardo; 02-18-2014 at 03:22 AM. Reason: Solved

  2. #2
    Registered User
    Join Date
    02-13-2014
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: run-time error 13 with code - Clearing Contents of cells

    My apologies I didn't realize there was a button for the code - that is my mistake. Attached is the solution to my issue.


    Please Login or Register  to view this content.

+ 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. [SOLVED] Help with Code - clearing contents of cells
    By sajanpatel15 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2013, 03:17 PM
  2. VBA code to clear the contents (or value) of a cell without clearing the formula
    By BazzaBit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2013, 08:16 PM
  3. [SOLVED] Clearing cells within an Array - Run-time error 13 (Type mismatch)
    By Wobbigone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2013, 01:37 AM
  4. [SOLVED] Clearing contents of only blank cells
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-29-2012, 09:35 AM
  5. clearing the contents of specified cells
    By Jimmy Pop in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2005, 09:05 PM

Tags for this Thread

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