Why doen't this assignment work

[Mackeral]

Definition Line

Public Test_Stings(20) as String

When I execute

Test_Strings(1) = "ABC"

I get this message

Run time Error
Type 13

I want "Test_Strings" to hold "Strings", not "Integers".

What have I not understood?

 

[Fluff]

I would suggest that you use Option Explicit. That would show that you have a typo.

 

[Mackeral]

The problem turned out to be that I was trying to also pass"Test_Strings" as an subroutine argument.

 

[Rick Rothstein]

For what you posted, and what Fluff was trying to lead you to, is that the spelling of your variable name in the Dim statement was different from that in your assignment statement. Using Option Explicit will protect you against that, and a whole host of other, errors.

 

[Mackeral]

I went back and fixed the calls, but I'm still getting a the same "Type Mismatch" error.

The argument definition is in the same module as the code.

 

[Mackeral]

I found another local definitions for "Test_Strings" defined as Interger. Took that out, and it works fine.

 

[Rick Rothstein]

I am glad you found the problem because I was about to write back that I saw nothing wrong with the code you showed us (once the variable names were taken care of).