LaBamba
09-29-2014, 12:15 PM
Hi guys,
I am using the following code to attach a formula as a string to a cell.
strFormula = "='[" & wbCustomerFile.Name & "]" & shPS.Name & "'!AL2"
It is returning this value in the cell.
='[Total 1.xlsx]NR'!'AL2'
Which is the correct notation...sort of. I need it to get rid of the last ' and the ' after the !.
What am i missing here?
Let me know.
Thanks,
I am using the following code to attach a formula as a string to a cell.
strFormula = "='[" & wbCustomerFile.Name & "]" & shPS.Name & "'!AL2"
It is returning this value in the cell.
='[Total 1.xlsx]NR'!'AL2'
Which is the correct notation...sort of. I need it to get rid of the last ' and the ' after the !.
What am i missing here?
Let me know.
Thanks,