I know the logic to do this scenerio, except i dunno how the summin
part works. My code is shown below

Worksheets(a).cells(i,j)Select
ActiveCell.formula = "=SUM(R[-z]C:R[-1]C)"


It seems that the second line is wrong. Do someone know the reason?

Thk u

--
Message posted from http://www.ExcelForum.com