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"
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks