Highlight Selected Cells

[vbabeginner92]

I am trying to create a macro that will highlight cells already selected. Below is the code I used but that is only working for the active cell. How can I alter the code to highlight all the cells I selected.

Example: Cell C15 is the active cell and cells C15:C20 are selected. When I run my macro, only C15 is highlighted, but I want cells C15:C20 highlighted.

Sub Highlighter()
ActiveCell.Interior.Color = RGB (255,255,0)
End Sub

 

[Fluff]

Replace ActiveCell with Selection

 

[Jack in the UK]

Sub Highlightx()
Dim myRange As Excel.Range
Set myRange = Range("C15:C20")

myRange.Interior.Color = RGB(255, 255, 0)

End Sub

 

[vbabeginner92]

Thank you! That worked perfectly!

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Jack in the UK]

All good thanks for posting back... open a test workbook and havea play and have some fun. Post in a new thread if you have any other questios

jiuk