I am trying to use the macro recorder, but when I select the first 6 rows of the spreadsheet and use the rows delete function it does not work when I play back the macro.
I have tried highlighting the rows and using the delete key, as well as right click and delete. When I play the macro back it does not select the rows and does not delete the rows.
What am I missing?