+ Reply to Thread
Results 1 to 2 of 2

Script not working Error13 Please help

  1. #1
    Registered User
    Join Date
    09-02-2012
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    19

    Script not working Error13 Please help

    Hello i'm using the following script and it is saying Error 13. I try to find the mistake but i couldn't find it. Little help will be much appreciated.

    Thanks for the help in advance.
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,192

    Re: Script not working Error13 Please help

    13 means you tried to assign the wrong data type....text to a number or combo box to a text, etc
    Looking here my guesses:

    Sheets("2") will only work if the sheet is ACUTALLY NAMED 2. (not sheet #2)
    if you want sheet #2 its: Sheets(2) (no quotes)

    guess 2:
    TextBox1.Value is not producing what you think.

+ 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. This script isn't working, why not?
    By ledworld in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 06:04 PM
  2. [SOLVED] VBA Script has stopped working
    By Philfy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-10-2013, 11:24 AM
  3. [SOLVED] my if-then-else script is not working
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2013, 02:24 AM
  4. see whether a range variable is nothing ;error13 - type mismatch
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2012, 06:58 AM
  5. Need vba script to look a worksheet and keep autofilter working
    By alinda in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2011, 03:32 AM

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