nevermind, i changed the line to: ActiveCell.Formula = "=estimating1!M48"
and if fixed the problem