Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If I drop the "X" part, the below will shade the cells I want. I just can't
get the syntax for adding - ActiveCell.Offset(0, 1) = "X". I have tried several versions of this with only undesired results. Any help would be appreciated. Thank in advance wal50 Sub MarkCells() Dim Cell As Range Dim MarkThis As String MarkThis = Application.InputBox("Enter Value to Mark", Type:=2) Set rng = Application.InputBox("Enter Range to check - A1:A20", Type:=8) rng.Select For Each Cell In Selection If Cell.Value = MarkThis Then Cell.Interior.ColorIndex = 4 And ActiveCell.Offset(0, 1) = "X" Next Cell End Sub |