Hi I need to write below formula in cell but its not working correctly:
='ProjectName_Regression Test'!E7
I am trying below code. Sheetname is a variable with value "ProjectName_Regression Test"
cells(1,1).formula = "=" & Chr$(34) & sheetname & Chr$(34) & "!E7"
Kindly Let me know what is wrong with this formula.
Bookmarks