hi,
I have the following code:
Code
-------------------
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.TextToDisplay = "CPO Reports" Then
a_variable = ActiveCell.Offset(ColumnOffset:=-3).Value
tofield = ActiveCell.Offset(ColumnOffset:=-5).Value
Select Case MsgBox("Email CPO?", vbQuestion + vbYesNo, "Confirm")
Case vbYes: Send_Unformatted_Rangedata (a_variable, tofield)
Case Else: Exit Sub
End Select
End If
End Su
-------------------
but it has a problem with the line:
Code
-------------------
Send_Unformatted_Rangedata (a_variable, tofield)
-------------------
as it displays an error saying "Compile Error Expected: ="
does anyone know what i'm doing wrong?
i'm sure i've passed two variables into another subroutine before...
thanks in advance,
Mat
--
matp
-----------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...fo&userid=2107
View this thread:
http://www.excelforum.com/showthread.php?threadid=52760