Ctrl-End

[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.

 

[Don Guillett]

Delete the un-necessary rows and SAVE the workbook.

 

[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.

 

[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

 

[Debra Dalgleish]

If you use Data>Form to enter new records, the formulas will be added
automatically. Or, you can use John Walkenbach's Enhanced Data Form (a
free add-in):

http://j-walk.com/ss/dataform/index.htm

It allows comboboxes, and unlimited fields.