How to Insert a hyperlink using VBA

[b_bop]

I want to locate the next available cell in a range of cells on one worksheet, and then create a hyperlink to a cell on another worksheet that I have just created within the same workbook. I am using Excel 2003, and for some reason when I try to record the macro to create a hyperlink it comes up blank. Suggestions?

Thanks,
Betty

 

[DRJ]

Try this

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet2!A1", TextToDisplay:="Sheet2!A1"