Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear all,
The code below is working to change the cell colour in one cell only within range(C4:C12). A message box appears when the user tries outside the range. Is it possible to change the code to enable change of a range of cells and also lets say C5 and C8 at the same time - within the range(C4:C12). The message box should appear when trying to change colour in lets say range(C6:C15). Sub White() If Not Intersect(ActiveCell, [C4:C12]) Is Nothing Then ActiveCell.Interior.ColorIndex = 0 Else MsgBox "It is only possible to change colour in C4 down to C12 " & vbNewLine & "in Column C only!", vbCritical, "Cell Colour Change" End If End Sub -- Regards, Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to count specific colour from cell range with varied colors? | Excel Worksheet Functions | |||
Count filled colour in cell in given range | Excel Discussion (Misc queries) | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
Change even rows to a predefined colour | Excel Programming | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming |