Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Box assigned to multiple spreadsheets
I have the VB script to change the background color of my cells working but I
would like it to change another cell in a different worksheet. Can anybody help me out with how to program the reference? Here is the VB script I'm using to change the colors at the moment Range("C5").Interior.ColorIndex = -4138 - Range("C5").Interior.ColorIndex |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Box assigned to multiple spreadsheets
Hi
With Worksheets("MyOtherSheet") .Range("C5").Interior.ColorIndex = -4138 - .Range ("C5").Interior.ColorIndex End with note the period in front of both Range. If you want to do it on all sheets Dim ws as worksheet For each ws in Activeworkbook.Worksheets With ws .Range("C5").Interior.ColorIndex = -4138 - .Range ("C5").Interior.ColorIndex End with regards Paul On May 12, 11:26*pm, LUKEMUDGE wrote: I have the VB script to change the background color of my cells working but I would like it to change another cell in a different worksheet. Can anybody help me out with how to program the reference? Here is the VB script I'm using to change the colors at the moment Range("C5").Interior.ColorIndex = -4138 - Range("C5").Interior.ColorIndex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update multiple spreadsheets in multiple workbooks | Setting up and Configuration of Excel | |||
Multiple spreadsheets | New Users to Excel | |||
how do i control double spreadsheets? | Excel Discussion (Misc queries) | |||
How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions | |||
Images cannot be assigned to Listview control | Excel Programming |