Sub Req_XLD()
'Application.Visible = False
Cells.Delete
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.excel-downloads.com/forum/forum-excel/index240.html?sort=replycount&order=asc" _
, Destination:=Range("$A$1"))
'.CommandType = 0
.Name = "index240.html?sort=replycount&order=asc"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = False
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingAll
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
[A1].Select
Cells.Find(What:="1 / 3", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
'ActiveWindow.LargeScroll Down:=-1
'Application.Visible = True
End Sub