phantom1975
MrExcel MVP
- Joined
- Jun 3, 2002
- Messages
- 3,962
I'm not sure how to do what I want. Here's an idea of what I am looking for:
If ActiveCell = range("A1:D10") Then
ActiveCell.Interior.ColorIndex = 33
End If
Basically, if any cell within the array of A1:D10 is selected, I want the background color to change.
_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-10-15 19:32
If ActiveCell = range("A1:D10") Then
ActiveCell.Interior.ColorIndex = 33
End If
Basically, if any cell within the array of A1:D10 is selected, I want the background color to change.
_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-10-15 19:32