View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_3_] Alan Beban[_3_] is offline
external usenet poster
 
Posts: 130
Default Loading 3 Dimensional Array

You obviously didn't give us all the relevant information; the following
works fine:

Dim TextArray() As String, CurrentLetter As String
ReDim TextArray(0 To 3, 0 To 3, 0 To 2)
CurrentLetter = "Y"
TextArray(0, 0, 0) = CurrentLetter
MsgBox TextArray(0, 0, 0)

Alan Beban

wrote:
Silly question to ask. I want to load a three dimensional array with
text. I am not sure how exactly to do this. I have a variable equal
to a letter:

CurrentLetter = "Y"

When I do this:
TextArray(0, 0, 0)= CurrentLetter

I get an error message saying "Expected Array".

How do I load the "Y" into the element 0,0,0?

TS