Search results

Hi Brown, many thanks for your help! I've solved it. "NewRow = Sheet1.Range("....").Value " is good. Quang

Dear all, I got an error while running this in exel VBA. Private Sub UserForm_Activate() Dim NewRow As Integer Dim i As Integer For i = 3 To 100 'i is preferred to row number NewRow = Worksheets("Sheet1").Range("$H$i").Value 'an error occurs here:confused: If NewRow = 0...