| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adjustine the range of a selected cell
Hi there,
I have written the following macro to change the color of a cell as selected. I am trying to adjust the macro where it will automatically add (6)cells to the right of the selected cell and apply the same format. the Macro is: Sub Macro2() ActiveSheet.Select With Selection.Interior .ColorIndex = 40 .Pattern = xlSolid End With Range("A1").Select End Sub Your help is greatly appriciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert selected cell value into next cell in range that is empty | Excel Worksheet Functions | |||
| Does the selected cell have a range name? | Excel Programming | |||
| Determining Range of selected cell | Excel Programming | |||
| Referencing the First Cell in Any Selected Range | Excel Programming | |||
| Macro run if and cell in range is selected in VBA | Excel Programming | |||
Threaded Mode
