Hi, all.
I have created a list where a tech claims x amount of account numbers, and his/her name is populated in the first blank cell in row c.
My code works, but I cannot reset back to C2 once the form is cleared. I clear all of the data from the sheet, but the code will give me an error unless there is data in the very last populated cell before I cleared it. Here's my code.
How can I clear the sheet and start fresh? IT's as if I need to reset a count, but I have no idea what to do
Code
Sub AssignBtn()
Dim TechName As String
Dim HowMany As Integer
TechName = Range("F2").Value 'This is a dropdown list of all names
HowMany = Range("F3").Value 'This is a dropdown list of the number of accounts that can be assigned at one time
For HowMany = 1 To Range("F3").Value
Range("C2").End(xlDown).Offset(1).Value = TechName
Next
End Sub
Display More