Hi

Does anyone know how i can get the following simple macro to repeat, but
following the hyperlink in the next cell down (which will be A3) and then
pasting the result 10 rows down (A13), and to continue the process (A4 and
A23, then A5 and A33..etc etc) until it reaches an empty cell and stops?

If anyone can help i'd be very grateful, thanks,
\sh

(i'm using Excel 2002 SP3)

----------------------------------------------------

Sub Test()
' Test Macro

' Macro recorded 02/11/2006 by \sh

' Keyboard Shortcut: Ctrl+p

Range("A2").Select

Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

Sheets("Sheet2").Select

ActiveSheet.Paste

Sheets("Sheet1").Select

Range("A3").Select

End Sub