Excel row/column add/delete events

Question

Hi,

I'm keeping a array of cell addresses which calls particular function. And I need to trigger all these functions in these cells When a user click a particular button.

But I could not find a way to update stored cell addresses whenever user delete/add a particular row/column.

Can somebody please suggest me a way of achieving this ?

Thank You

Answer 1

Is there any possibility to set a name to a cell within a function ?

Thank you