View Single Post
 
Old 01-23-2018, 11:44 AM
JohnnySTI JohnnySTI is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Jan 2018
Posts: 7
JohnnySTI is on a distinguished road
Default

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
---
Reply With Quote