Quote Originally Posted by patel45 View Post
sub a
LR = Cells(Rows.Count, "A").End(xlUp).Row
for r = 1 to LR
  cells(r,3) =  cells(r,1) + cells(r,2) 
next
end sub
tq.. its work.. but is tat I can set the entire cell formula will follow the formula in cell C1?