1
2
3
4
5
6
7
8
9

For i = 1 To Sheets.Count
	firstSheet = Sheets(1).Range("D3").Value
	If Sheets(i).Rows.Count >= 3 Then
		ActiveSheet = Sheets(i).Range("D3").Value
		Sheets(i).Select
		Sheets(i).Name = Sheets(i).Range("D3").Value
		objExcel.run "Highlight_Results_Macro.xls!testMacro"
	End If
Next