end(xlup)

D

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
 
B

BrianB

Presumably you want something like this :-

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