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

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

    Tuesday, December 31, 2019 6:15 AM

All replies

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


    Tuesday, December 31, 2019 10:46 PM