Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "JLGWhiz" wrote: Your public Dim does not match your ReDim variable names. JLG, I have these specified above: Dim arrSelectedFiles() As String Dim arrSelectedSpecies() As String Dim arrSelectedLayers() As String Then in the second Sub routine, I have these below, which I refer to later in the first sub. THe problem is, after I return from the second, I no longer have these arrays! I'm so frustrated! ReDim Preserve arrSelectedFiles(1 To lngFileCount) ReDim Preserve arrSelectedSpecies(1 To 10) ReDim Preserve arrSelectedLayers(1 To 4) Thanks, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LOSING FORMATS | Excel Discussion (Misc queries) | |||
Keep Losing VBAProject | Excel Programming | |||
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Losing the #DIV/0! | Excel Worksheet Functions |