Redim Preserve Change LBOUND

[mailmaverick]

Hello

I have a single dimensional array in which I want to change lower bound, keeping the upper bound as same.

One way is to loop through the array and copy the desired values to a new variable. But, is there any shortcut or direct function ?

[cytop]

Not really. Chip Pearson has a whole page of array functions including ChangeBoundsOfArray at http://www.cpearson.com/excel/vbaarrays.htm

[kalbasiatka]

Not really http://www.cpearson.com/excel/vbaarrays.htm

And you do read what is written there? Same shifting from one array to another.

[cytop]

Yes, I did read it, a long time ago.

I would have assumed the original poster would come to the conclusion that changing the lower bound of an array is not really a practical thing to do. A possible way to work it was mentioned in the post

One way is to loop through the array and copy the desired values to a new variable

- so ending up with a new array does not seem to be out of the question.

The link was offered so that perhaps he (or she) might be able to find some way to accomplish what they want - but to be honest, I can't think of a reason to change the lower bound of any array.

I do hope I have explained myself to your satisfaction.