Fri 18 May 2007, 15:03Delegate Robert said...
Robert has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Looping macro to find chunks of data
I have a selection of reports which place one large chunk of data I need to select in random places.
I thought maybe a loop with the offset command to find it would work but cant think of how to write this.
any ideas?
Fri 18 May 2007, 16:06Trainer Garry said...
RE: Looping macro to find chunks of data
Private Sub CommandButton1_Click()
Dim Cell As Range, SelectedRange As Range, X As String
X = InputBox("enter Name")
Set SelectedRange = Range("A1").CurrentRegion
For Each Cell In SelectedRange
If Cell = X Then
Cell.Font.ColorIndex = 3
End If
Next Cell
End Sub
