[sparky222]

Help - can anyone help me with a concatenation statement in VBA for excel?

What I'm writing is a macro to create a link referencing a cell in the excel worksheet and I don't know how to concatenate the cell contents into the macro.

Code below:

Sub hyperlink()
'
' hyperlink Macro
' Macro recorded 11/25/2004 by
'

'
Dim Link As String
Dim Link2 As String

Link2 = z1 ' should pick up the contents of cell z1
Link = ("http://www.ourladyofloreto.org/bulletins/" & Link2)
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
Link

' ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
' "http://www.ourladyofloreto.org/bulletins/050102/050102.02.htm"
End Sub