Please forgive me, but I'm on a very steep learning curve. I'm not sure where to put this code. I already have code for the "UserForm_Initialize()" event as shown here
Private Sub UserForm_Initialize()
LastRow = FindLastRow
GetData
End Sub
Do I need to delete this code and replace it with the code you suggested (and include the line "GetData")?
Also, I am guessing I should delete the existing code for finding the last row.
Private Function FindLastRow()
Dim r As Long
r = 2
Do While r < 65536 And Len(Cells(r, 1).Text) > 0
r = r + 1
Loop
FindLastRow = r
End Function
Thanks for your patience. Rome wasn't built in a day"
Bookmarks