Need Excel VBA Array Help Problem Accessing Array

tim_crouse · May 24th 2020

I have a dynamic array that gets assigned it's values via a 1D range assignment.

For Debugging purposes I wanted to be able to display elements of the array.

And I wanted to retrieve two elements (3 and 4, zero based index):

1. Element(3) if element 3 contains the letters "3P" value I wanted to increase the next array element value by 2

2. Element(4) increase by 2 if the value existing in element 3

3. Re-Insert the adjusted element 4 into the array.

The export data tab shows the 1D array placement into the spreadsheet.

Could someone show me what I am doing wrong so that I can get access to the array values?

The code in question is on the Acad Template Tab >> Export Sched Button

Thanks In Advance

Tim C.

tim_crouse · May 24th 2020

Re-Send of Updated Spreadsheet >> Acad Template "APPLY" button code was looking at the wrong ref column.

trunten · May 25th 2020

do these little tweaks help at all?

Code

 MsgBox ws.Range("O" & RowToCopy & ":" & "S" & RowToCopy).Address ' doesn't work

 MyArray = ws.Range("O" & RowToCopy & ":" & "S" & RowToCopy).Value
                    
 Debug.Print MyArray(1,1)
 MsgBox "LBound: " & LBound(MyArray) & " UBound: " & UBound(Myarray)

Need Excel VBA Array Help Problem Accessing Array

Participate now!

Share

Tags