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)