Delete last item in an 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?

Thanks
A

 

[strongm]

You might want to ask your question here: forum707