![]() |
|
#1
|
|||
|
|||
![]() Quote:
Code:
Application.WorksheetFunction.Max(Range("C5:C" & lastrow)) + 1 |
#2
|
|||
|
|||
![]()
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 --- |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |