how to get excel new records can follow last record when reopen VB project since vb project get end(or exit) last time

Question

hello masters

      my problem is that i try to make excel new records follow last record not recover last records from  the first record while i reopen my VB project since VB project got end last time.

   my vb project  is for questionare collection, i set option controls to collect people's options and put option results into excel to be saved . later records need to follow former records by the last one. but my vb project can not make it, everytime running vb project , people's options always recover former records from the first record in excel, im Racking your brains and trying all ways in vain. im here to ask your help and thanks lot.

Answer 1

To: J...
Re:  not quite clear what you want

To find the last row with data in a particular column use:

Sub testing()
  Dim LastRw As Long
  LastRw = ActiveSheet.Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row
  VBA.MsgBox "The last row, with data, in column(1) is: " & LastRw & "  "
End Sub
'---

The free Custom_Functions add-in has 20 new Excel functions including
the 'vLookUpAny' function and the 'Switches' function (similar to the Switch function)
Download from...
http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents