Delete last item in Array

[haybarr]

Hi,

Each time a user opens my workbook I create an array of projects from the main worksheet. The user is then able to delete and edit the projects using user forms.

My problem arises when the user deletes all of the projects, can someone please tell me how to delete the last element in an array?

I have tried to Redim to -1 and 0 but throws an error...

Thanks
A

 

[PHV]

Something like this ?
Erase yourArray

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[haybarr]

Thanks, perfect.