ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loading 3 Dimensional Array (https://www.excelbanter.com/excel-programming/275717-re-loading-3-dimensional-array.html)

Alan Beban[_3_]

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




All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com