Thread: [Solved] recording ranges in macros
View Single Post
 
Old 09-13-2017, 02:32 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default

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"?
Reply With Quote