end(xlup)

[dadda]

Hi ;
In a spreasheet I enter different datas, ligne after line,
by correspondent textboxes on a userform.
I'D like to continously keep an area of five lines after
the latest line i've entered what ever it would be.
Those five lines are reserved for comments whose i enter
by a special textbox on a same userform.
any help will be appreciate.
thank's

 

[BrianB]

Presumably you want something like this :-

NextRowToUse = ActiveSheet.Range("A65536").End(xlUp).Row +