So if I want it to pik up the first cell in row 13 and place it in 1
would it look like this.

ActiveCell.Value = Cells(0, 13).Value = Cells(0, 13).Value +

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