![]() |
|
#7
|
|||
|
|||
|
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"? |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Recording Macros in Word
|
doingwork | Word VBA | 1 | 10-10-2015 12:54 AM |
Problems with Recording Macros
|
jekronenfeld | Excel | 6 | 09-26-2013 03:07 PM |
Recording Macros in Word
|
cameron.fairfull | Word VBA | 2 | 09-08-2011 08:24 AM |
| Recording Macros Tutorial? | Madhouse | Word VBA | 1 | 04-28-2010 01:32 PM |
| Tutorial recording macros | Jaffa | Word VBA | 0 | 04-27-2010 09:14 PM |