|
|
#10
01-23-2018, 11:44 AM
|
|||
|
|||
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 --- 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Simple Spread Sheet
|
TThomas | Excel | 1 | 04-07-2016 09:01 PM |
| extract specific pivot table data to a new sheet | theexpat | Excel Programming | 0 | 02-18-2016 10:08 AM |
|
Using combobox to pass data from an Excel spread sheet to text boxes on userform
|
Stewie840 | Word VBA | 14 | 12-17-2015 10:13 PM |
| changing the spread sheet location on embeded pie chart | otuatail | PowerPoint | 1 | 03-04-2014 07:20 AM |
| Condensing a spread sheet | hawkeyefxr | Excel | 4 | 08-22-2012 05:17 AM |
Windows 10 
Office 2010 64bit
Threaded Mode