1st error was "Variable not defined" which was "lastrow"
I Dim it as "Range" then got
Run Time error '91':
Object variable or With block variable not set
I tried below but it didn't work
---
lastrow = Me.Controls("Reg1").Value
'Reg1 is the ID control box name and column name for the ID numbers
---
|