I have this macro that copies information for a selected cell. It uses the
information to goto a weblink copies the information and returns it to z3. my
problem is that i only need information from the b cells but it is grabing
the a cells as well. As suggestions?
weblink http://www.geocities.com/btobin0/17May2006.html
excel cells = Z2 for active cell : Z3 to paste information
information in z2 = 17May2006

macro:

Sub Macro3()

'ActiveCell.Value
Selection.Copy
'Application.CutCopyMode = False
'Application.DisplayAlerts = False
Workbooks.Open Filename:= _
"http://www.geocities.com/btobin0/" & ActiveCell.Value & ".html"
Range("B10").Select
Selection.UnMerge
Range("B10:B20", "B22:B32").Select
Selection.Copy
ActiveWorkbook.Close
'Application.DisplayAlerts = False
Sheets("Sheet1").Select
Range("z3").Select
ActiveSheet.Paste

End Sub