Hi all,
I have two ranges which I would like my users to be able to Insert or Delete the last row but to keep the formatting of the inserted row from the one above.
The code seems to work fine but it does not prevent the user from deleting the last row. Once this is done I think the code looses it’s reference points and then it all goes wrong. I would be grateful if someone can tell me how to prevent the last row in the range from being deleted. Cell C32 is the top left cell start of my range. Any simplification on my code would also be welcome.
Thanks
Bookmarks