Ctrl-End

  • Thread starter Thread starter Creperum
  • Start date Start date
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.
 
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.
 
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
 
Back
Top