Thanks guys for the advice...let me give an example of what I want to do...
I want to be able to select a group of cells and in every other cell, I want to delete the contents. So if I have something like this...
A1...5
A2...3
A3...2
A4...6
I want to run the macro and have it look like this...
A1...5
A2...(blank)
A3...2
A4...(blank)
..The problem is I want the macro to apply to whatever I have selected at the time and not to those same cells every time. Can I just delete all the cell references in the macro and replace it with something like "SetRange Selection"?
|