Hi

The below is a path and file name where i am saving a
certain file to through VB:

Remit_Name = file_path & "\" & Supp_Name & " " & Trans_No
& " " & Format(Date, "ddmmmyy") & ".xls"

I am using a concatenate function somewhere else on the
sheet where i need to call this value from. Is there any
way of calling a VB variable from a worksheet cell?

For eg i want a formula to read:

=Concatenate(a1:, b76, Remit_Name)

Assuming Remit_Name is a public variable

Public function RName()
Application.Volitile
rName = Remit_Name
End sub

Place the above in a general/standard module, then you can use

=Concatenate(a1, b76, RName())

--
Regards,
Tom Ogilvy


"Edgar" wrote in message
...
Hi

The below is a path and file name where i am saving a
certain file to through VB:

Remit_Name = file_path & "\" & Supp_Name & " " & Trans_No
& " " & Format(Date, "ddmmmyy") & ".xls"

I am using a concatenate function somewhere else on the
sheet where i need to call this value from. Is there any
way of calling a VB variable from a worksheet cell?

For eg i want a formula to read:

=Concatenate(a1:, b76, Remit_Name)