Calling subroutines and passing variables

hi,

I have the following code:

Please Login or Register  to view this content.

but it has a problem with the line:

Please Login or Register  to view this content.

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,
Matt

Try

Call Send_Unformatted_Rangedata (a_variable, tofield)

or

Send_Unformatted_Rangedata a_variable, tofield

--
Regards,
Tom Ogilvy



"matpj" wrote:

>
> 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 Sub
> --------------------
>
>
> 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,
> Matt
>
>
> --
> matpj
> ------------------------------------------------------------------------
> matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
> View this thread: http://www.excelforum.com/showthread...hreadid=527607
>
>