Ctrl-End

C

Creperum

So I entered a formula into the third row of a cetain column. I copied
the formula and pasted it all the way down to row 20,000... but now
everytime I hit ctrl-end it goes to row 20,000 and the formula that was
pasted there. I need it to go to the last row I've entered, how can
this be fixed? Is there a better way to make the formula work for
every cell below row three in that column? And can you prevent the
formula from accidentaly being deleted from the cell?

Thanks.
 
C

Creperum

Well, of course thats going to fix my ctrl-end problem, but then
everytime I enter a new line I have to copy-paste the formula again to
the new row. I appreciate the obvious answer though.
 
D

Don Guillett

Something like this, assigned to a button/shape, might be useful. Adjust to
suit

Sub newline()
Cells([checksA].Rows.Count + 7, 1).Select
with ActiveCell
.Offset(0) = .Offset(-1)
.Offset(0, 4) = 1
end with
End Sub
 
Top