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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adjustine the range of a selected cell
Try something like this:
Sub PaintMeAndSixCellsRight() With ActiveCell.Resize(Columnsize:=7).Interior .ColorIndex = 40 .Pattern = xlSolid End With Range("A1").Select End Sub Is that something you can work with? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "abumustapha" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
adjustine the range of a selected cell
Hi
Look at this Sub Macro2() ActiveSheet.Select aCell = Selection.Address Range(aCell, Range(aCell).Offset(0, 6)).Select With Selection.Interior .ColorIndex = 40 .Pattern = xlSolid End With Range("A1").Select End Sub Regards, Per "abumustapha" skrev i meddelelsen ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
adjustine the range of a selected cell
Try:
Sub Macro2() With Selection.Resize(1, 6).Interior .ColorIndex = 40 .Pattern = xlSolid End With End Sub Good luck. Ken Norfolk, Va On May 19, 2:41*pm, abumustapha wrote: 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 |
Reply |
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 |