Hi,

Excel 97
I have a macro attached to a button that copies previously marked data
from a
web page to cell D8 on a tempory download sheet, where it is formatted
and then copied to another sheet.

Sub DownloadTABdata()
'
' DownloadTABdata Macro
' Macro recorded 1/06/05 by IBM
'
ActiveSheet.PasteSpecial Format:="Text", Link:=False,
DisplayAsIcon:= _
False


End Sub

Now the data arrives with a list of numbers in col D8:Dxx and names in
col F8:Fxx. I want to move the data in F8:Fxx to E8:Exx. The data
range is variable from , say, 6 to 24 items.

After the column move, I want that range (D8:Exx) marked ready for
copying on to another sheet.

Can anyone help with a bit of code to accomplish this task?

Thanks,
Neddy


--
Neddy
------------------------------------------------------------------------
Neddy's Profile: http://www.excelforum.com/member.php...o&userid=24345
View this thread: http://www.excelforum.com/showthread...hreadid=379455