Dynamic arrays

Hi Alex

Thanks for getting in touch. This one is tricky to diagnose without seeing the file you are working on. But in general Microsoft recommend that you phrase it e.g.

ReDim Preserve myArray(5) As Integer

Are you able to send over a copy of the file? My address is

gary@stl-training.co.uk

If that's not possible, even just the line you are using to declare that array initially, and then the line to redefine the array would be useful to know. In the meantime, here is a link to Microsoft's article on ReDimming:

http://msdn.microsoft.com/en-us/library/w8k3cys2 (v=vs.80).aspx

This article is for VB generally but can apply to Excel.

Kind regards

Gary
Microsoft Office Specialist Trainer