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
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