PC Review


Reply
Thread Tools Rate Thread

subscript out of range

 
 
Bandit
Guest
Posts: n/a
 
      9th Apr 2008
What does this error msg mean. I made several copies of the database I am
working on. Then tried to split one. I have never done this or seen it
done. The msg I got was "subscript out of range". Any ideas? I will need
to split this database soon and am just now experimating with it it.
--
Bandit
 
Reply With Quote
 
 
 
 
Tom van Stiphout
Guest
Posts: n/a
 
      9th Apr 2008
On Tue, 8 Apr 2008 18:01:01 -0700, Bandit
<(E-Mail Removed)> wrote:

This was probably a runtime error. When that happens, hit Ctrl+Break
to break into the code, and you can probably figure out what happened.

A subscript is also known as an array index.
dim s(5) as string
dim i as integer
for i = 1 to 10
msgbox s(i)
next
This will generate the error when i reaches 6, because s(6) does not
exist.

-Tom.



>What does this error msg mean. I made several copies of the database I am
>working on. Then tried to split one. I have never done this or seen it
>done. The msg I got was "subscript out of range". Any ideas? I will need
>to split this database soon and am just now experimating with it it.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subscript out of range, and more John Pierce Microsoft Excel Programming 5 6th Jan 2009 04:07 AM
subscript out of range Judi Microsoft Access External Data 1 28th Aug 2008 06:48 AM
9: Subscript out of range jenz21985 Microsoft Excel Misc 6 5th May 2006 04:36 PM
Range Find got Subscript out of range =?Utf-8?B?UFQ5MTc0NQ==?= Microsoft Excel Programming 5 19th Jan 2006 12:06 AM
Re: Subscript out of Range on Range reference Tom Ogilvy Microsoft Excel Programming 0 13th Sep 2003 04:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:21 PM.