How do I write a macro to do the following:
Suppose the active cell is A1. I need to delete rows - 1,2,3,6,10,12,13 and 14.
But I need to it be relative to where the active cell is. I've tried recording it but it keeps going back to A1 and doing the macro again. I need it to perform the task starting wherever the active cell is
Any ideas?
Suppose the active cell is A1. I need to delete rows - 1,2,3,6,10,12,13 and 14.
But I need to it be relative to where the active cell is. I've tried recording it but it keeps going back to A1 and doing the macro again. I need it to perform the task starting wherever the active cell is
Any ideas?