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