i have a macro that does this on a line:

ActiveCell.FormulaR1C1 = "=estimating1!M48"
yet what it returns on the sheet is =Estimating1!'M48'

notice the ticks on M48. how can i get rid of these? when i run the macro, what happens is i get #NAME?

can anyone assist me?