View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default array: subscript out of range

You shouldn't get spelling errors VBA cna catch them for you add the line:

Option Explicit

At the top of your code. VBA can add this line for you automatically
whenever a new sheet or module is added by changing The VBA option

Tools - Options - Editor - Require Variable Declarations

With this checked VBA will not run any code where any variables are not
declared or where there are spelling mistakes...

Hope this helps...

"rachel" wrote:

Oops... caught a spelling error:

Line Input #lngInputFile, strInText
strArray = Split(strInTest, "~")


Duh. Of course, that probably won't be the only problem i run into, but at
least I caught (belatedly) one thing...

rachael