Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop macro in selected range
Hi,
I am new to VBA. I dug up a macro on the web somewhere. It does what is has to do, but only for the active cell. When I select multiple cells the macro only works on one cell. I would like it to loop, and do all the cells. I tried recording a macro for a selection, but only got this: Range("A1:A4,C7,D9,A11:G11").Select Range("A11").Activate Application.Run "Macro1" and that several times This is what I would like: I've selected A1:A4,C7,D9,A11:H11 The excisting macro is named Macro1 and gives the cell a red color. If I run the macro now only A11 turns red. I would like a macro that repeats Macro1 for the active selection. Can anybody tell me how this is done? Thanx, Sjaak |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop thru range and determine if filename exists in selected folder | Excel Programming | |||
trying to delete selected range with macro | Excel Programming | |||
Macro run if and cell in range is selected in VBA | Excel Programming | |||
Macro run if and cell in range is selected in VBA | Excel Programming | |||
TO TOM OR KEN: macro to calculate selected range | Excel Programming |