+ Reply to Thread
Results 1 to 3 of 3

Case inside a Case throws error 424

Hybrid View

  1. #1
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,922

    Re: Case inside a Case throws error 424

    CS is column 97 so the code for column 98 is never executed. Also, column numbers are long integers not strings so the cases should be written
    Case 1 not Case "1"
    Case 98 not Case "98"
    Ben Van Johnson

  2. #2
    Registered User
    Join Date
    06-09-2011
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Case inside a Case throws error 424

    Thanks for the reply pro. Fixed the column numbering to "case x" and extended the column across to column 98. It is still throwing an error 424. I am starting to look into memory issues. But anyone with any insight is greatly appreciated!

    **Edit**

    OK, I "fixed" the issue with

    On Error Resume Next

    Anyone with any input greatly appreciated however, Thanks!
    Last edited by Jon.R; 01-08-2013 at 03:44 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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