Excel macro question - VBA scripting crap

[Z]

Dunno if anyone will be able to help, with the recent general absence of GtDS, but here goes:

Want to set up a macro to have a hyperlink from one cell to a range of cells on another worksheet in the same book. Easy, but repetitive to do manually. If I just record the macro, I'm stuck with whatever cell reference I use when recording the macro and have to go back in and change the range to what I'd like. Can I have it prompt me for the range easily or can I have it leave me in the hyperlink window to edit the range? I can't stop the macro recording while the hyperlink window is open, and am not sure how to generate the code or wildcard that I'd need to do so.

Here's the recorded code:

Sub LinkMacro()
'
' LinkMacro Macro
' Macro recorded 11/8/2007 by Z
'
' Keyboard Shortcut: Ctrl+e
'
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"'SheetSheet'!A1"
End Sub

[Greg the dogsitter]

Please try:

Sub MakeHyperLink()

Dim rngTarget As Range
Set rngTarget = Application.InputBox(Prompt:="Please select a target range.", Title:="Howdy", Type:=8)

ActiveSheet.Hyperlinks.Add Anchor:=Selection, SubAddress:=rngTarget.Address(External:=True), Address:=""

End Sub

[Greg the dogsitter]

Any word? Did it work? Hm? Huh? Don't make me lose sleep. :-)