Hello,
Jim was good enough to put me on the right track, but I'm still
confused a bit (OK, a lot).
Here is the code and the explantion within it,
Sub DownloadFormatCopyTAB()
'
' DownloadFormatCopyTAB Macro
' Macro recorded 17/06/05 by IBM
'
' Downloads TAB data from web, formats and copies to
' TodaysRaces sheet at selected cell. Only cols D and E from
' the downloaded data are used.
'
ActiveSheet.PasteSpecial Format:="Text", Link:=False,
DisplayAsIcon:= _
False
'Note the range downloaded contains data in cols D to Q.
'only cols D and E are required.
Range("F8", Range("F8").End(xlDown)).Cut Range("E8")
Selection.Copy
' How do I select only D8:Exx to copy across???
Sheets("TodaysRaces").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
.................................................. ....
The above works, but copies the whole lot across, instead of the
required
range D8:Exx. The downloaded data has variable items.
Thanks
Neddy
--
Neddy
------------------------------------------------------------------------
Neddy's Profile:
http://www.excelforum.com/member.php...o&userid=24345
View this thread:
http://www.excelforum.com/showthread...hreadid=379937