Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to arrays
Hi
I'm new to arrays and although I think I can work most of it out using the help file, i'm struggling to find out how I add to an array. e.g. a=(1,2,3,4) How can I add 5 to the end Your help would be much appreciated. Many Thanks Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to arrays
Check out the ReDim method in VBA help.
"Steve" wrote: Hi I'm new to arrays and although I think I can work most of it out using the help file, i'm struggling to find out how I add to an array. e.g. a=(1,2,3,4) How can I add 5 to the end Your help would be much appreciated. Many Thanks Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to arrays
Thanks, I can see that this resizes teh array but still not sure how to add
to the array. Maybe I'm missing something here!!# Cheers Steve "JLGWhiz" wrote: Check out the ReDim method in VBA help. "Steve" wrote: Hi I'm new to arrays and although I think I can work most of it out using the help file, i'm struggling to find out how I add to an array. e.g. a=(1,2,3,4) How can I add 5 to the end Your help would be much appreciated. Many Thanks Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to arrays
Dim a
ReDim a(1 to 4) a=Array(1,2,3,4) ReDim Preserve a(1 to 5) a(5)=5 Alan Beban Steve wrote: Thanks, I can see that this resizes teh array but still not sure how to add to the array. Maybe I'm missing something here!!# Cheers Steve "JLGWhiz" wrote: Check out the ReDim method in VBA help. "Steve" wrote: Hi I'm new to arrays and although I think I can work most of it out using the help file, i'm struggling to find out how I add to an array. e.g. a=(1,2,3,4) How can I add 5 to the end Your help would be much appreciated. Many Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding arrays from multiple workbooks | Excel Programming | |||
Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
Adding arrays | Excel Programming | |||
Adding Arrays | Excel Programming |