I have a sheet for inputting information and I have a button that adds a row at the bottom and a button on each row that deletes that row, including all the buttons on that row.
The macro for inserting a new row always works and the macro that deletes a row works when the workbook is first opened. The delete macro works after any of the other macros in the workbook are run but if I run the add row macro the delete macro stops working after that.
Here are the two macros:
Addrow
Delete Row
After the add row macro has ran the delete macro gets a run time 1004 error and highlights
If Not Intersect(shp.TopLeftCell, rng) Is Nothing Then
Can anyone tell me why this is happening and how to stop it, or just a way to work around it if not?
Bookmarks