How to prevent the last row of a range from being deleted ?

**Greycom4** · 08-14-2013, 06:31 AM

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.

Please Login or Register  to view this content.

Thanks

**:) Sixthsense :)** · 08-14-2013, 06:48 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

**Greycom4** · 08-14-2013, 03:07 PM

Sorry about that, I did wonder how that was done.

**Greycom4** · 08-21-2013, 06:54 PM

Perhaps I have not explained this very well. My code works in that I can delete the last row in the range which is fine, however if the range contains the first row with headers and 4 rows with details, I want the user to be able to remove the last three rows (one at a time) until they get to the last row. I need to prevent the users from deteling the last row of details in the range so they are left with the headers and one row of data.