Hello All,
I have a relatively simple task but my attempts have not been sucsessful. Can anyone please help with the following:
I have a worksheet that I basically want to delete 1 row above the referenced rows. So "AZ1"& "AZ4" are the 2 cells that i use as a dummy to identify the last row of particular tables.
Essentially what I would like to do is if the user clicks the button delete row it will delete 1 row above AZ1 & AZ4. I did write a code to insert rows by referencing these 2 cells here but cannot figure out best way to delete 1 row above these references. Any help is much appreciated as always:
I have a relatively simple task but my attempts have not been sucsessful. Can anyone please help with the following:
I have a worksheet that I basically want to delete 1 row above the referenced rows. So "AZ1"& "AZ4" are the 2 cells that i use as a dummy to identify the last row of particular tables.
Essentially what I would like to do is if the user clicks the button delete row it will delete 1 row above AZ1 & AZ4. I did write a code to insert rows by referencing these 2 cells here but cannot figure out best way to delete 1 row above these references. Any help is much appreciated as always:
Last edited: