Sub Querry_aa()
'Macro écrite par Claudy
'Corrigée le 18/10/2014
Application.ScreenUpdating = False
'source:
Application.ScreenUpdating = False
Feuil1.Visible = True
Sheets(1).Activate
Cells.Select
Selection.ClearContents
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.voleur/fr/toto/kiki" _
, Destination:=Range("A1")) 'adapter avec l'URL réelle
.Name = "lastresults"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
Range("A73").Select
'///
Dim var
Dim i&
Dim k&
Dim bool As Boolean
var = ActiveSheet.UsedRange
For i& = 1 To UBound(var, 1)
If Len(var(i&, 1)) > 7 Then
For k& = 1 To Len(var(i&, 1))
If Not IsNumeric(Mid(var(i&, 1), k&, 1)) And Mid(var(i&, 1), k&, 1) <> " " Then
bool = True
Exit For
End If
Next k&
'---
If Not bool Then
ActiveWindow.ScrollRow = i&
Range("a" & i& & "").Select
Exit For
End If
bool = False
End If
Next i&
'///
Exit Sub
End Sub