I am having trouble and I think the answer is simple, but I cannot find it or figure it out. I have a table, say 3 rows x 3 columns. I have vba that when I doubleclick on a row, it inserts a new row below where I clicked and copies the values from the cells above to the new row. What I want is code for column 3 to fill the cell below so the number in say cell C1 increases by 1 and is put in the new cell C2. This needs to be variable as the table grows, so that if I doubleclick on row 20, which then adds a new row below and copies the values from above except for column 3, which will autofill the cell value from the row clicked on, add 1 and put that value in the cell below. Thanks for any help.