Originally Posted by patel45 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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks