Autofill help

[thecdnmole]

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.

[TMS]

Post your code and, ideally, a sample workbook.

[thecdnmole]

Sure, pretty simple code, but it's the autofill I can't figure out. So the code inserted a row and copied the cells, thus C3=C2, but what I want is when it
inserts the new row, it fills like C7 did from C6.

Please Login or Register  to view this content.

[thecdnmole]

I am trying this code, which is close, but it puts the value at the end of the column, not in the blank cell in the newly created row.

Please Login or Register  to view this content.

[mike7952]

Maybe this

Please Login or Register  to view this content.

[thecdnmole]

Maybe this

Please Login or Register  to view this content.

Thanks mike7952! Pretty well what I need, other than column B not copying, but I might be able to get that. I tried it in combo with what I had and it seemed to work. Great!

[mike7952]

Thanks mike7952! Pretty well what I need, other than column B not copying, but I might be able to get that. I tried it in combo with what I had and it seemed to work. Great!

On your uploaded example workbook column B is coping for me

[thecdnmole]

On your uploaded example workbook column B is coping for me

Yes it does and now I have it figured out for the true table I am using! Thanks!!

[mike7952]

Your welcome