Hi Guys
I am trying to find out how to use Application.WorksheetFunction. to simply use the =
I want to change this:
[a1] = "='C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!$B$28"
Into something like this:
Variable = Application.WorksheetFunction.Equals("C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!$B$28")
Is this possible?
Thanks in advance

I am trying to find out how to use Application.WorksheetFunction. to simply use the =
I want to change this:
[a1] = "='C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!$B$28"
Into something like this:
Variable = Application.WorksheetFunction.Equals("C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!$B$28")
Is this possible?
Thanks in advance

Last edited: