I've been researching thisbut none of the answers I found seemed to make sense in what I am doing.
I have the following code:
' find last row
findlastrow = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
lastrow = findlastrow
lastrow = lastrow - 1
' set...