vba courses london - Looping macro to find chunks of data

Resolved · Low Priority · Version Standard

Fri 18 May 2007, 15:03 Delegate 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:06 Trainer 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

View all VBA hints and tips