Re: VBA "String" Verhalten verstehen

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Frank
Date: 01/20/05 

Date: Thu, 20 Jan 2005 12:04:52 +0100

Hallo Gruhler P.-G.,
der Fehler liegt in der Variablendefinition. Du hast ausdrückich
festgelegt: L05(1) As String. Die übrigen Array-Variablen wurden durch
Weglassen der Deklaration von XL als Variant deklariert.

Abhilfe:
Definiere:
Dim L01(1) as Variant
Dim L02(1) as Variant
Dim L03(1) as Variant
Dim L04(1) as Variant
Dim L05(1) as Variant

oder

Type Liste
  Name As String
  Number As Integer
End Type

Sub Prozedurname()
Dim L01(0) As Liste
Dim L02(0) As Liste
Dim L03(0) As Liste
Dim L04(0) As Liste
Dim L05(0) As Liste
...
End Sub

MfG Frank
_____________________________________________
Frank Arendt-Theilen, Microsoft MVP für Excel, Hameln
Website: http://www.xl-faq.de; Auftragsprogrammierung

Relevant Pages

  • Re: How to read CSV in Ruby 1.9.2
    ... with this line you get rather false results if you have a string value in a ... csv file which contains ',' oder ';'. ... Thomas Preymesser ...
    (comp.lang.ruby)
  • Re: Verzeichnisse kopieren
    ... Use of uninitialized value in concatenation or string at ./projects/backup.pl/backup.pl line 25. ...
    (de.comp.lang.perl.misc)
  • Re: ArrayList in String Konvertieren
    ... public static String join(final Listlines, final String glue) ...
    (de.comp.lang.java)
  • Performance question with a string concat
    ... I want to let grow a string variable within a loop. ... A non-interpolated string '' is said to be faster than the usual "" string. ... oder b.) ...
    (comp.lang.perl.misc)
  • Re: Formulare
    ... wo alle Labels rechts- und alls Felder linksbündig ... String getError{... ... String getName() ... Hole die Liste mit den Fehlern und falls da welche sind, ...
    (de.comp.lang.java)