Data from a specific row in a spread sheet into a form

NoSparks · #1 01-23-2018, 09:37 AM

Quote:

All my code works as it should. This issue is generating a new ID

I'd use

Code:

Application.WorksheetFunction.Max(Range("C5:C" & lastrow)) + 1

JohnnySTI · #2 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