Hello,
how can we use to get the range endof records of the cells without to use this last part of code below
is there an solution to use it so we don't have to add :S100000 of rows?.Range("S8:S100000".Find(What:=Me.ListBox1.Column(17), LookIn:=xlValues, LookAt:=xlWhole))
because i believe if there are many more records it will not be able to search them all.
Thanks