Hi all,

I am trying to extend the range of an existing defined range. I have tried to offset the range, resize the range and I just can't get it to work.

Here is what I am trying to do....

Existing range $A$2:$A$42, I want code that will change the range to $A$2:$A$43 and obviously everytime I run the procedure it extends the range by one.

Is there a simple way to do this

Thx
Steve