I am having difficulty remembering the code to delete rows I do not require in a large spreadsheet. If the cell to the left of the active cell contains a certain word (say "NONE") I want to delete the entire row plus the three rows beneath.
Can anyone help
Thanks
Can anyone help
Thanks