I've been trying to get the last column with data in my spreadsheet.
However, what I want to do is to start at a certain row and move upwards. Most of the code I've found looks at the entire spreadsheet.
I am using the below code to find the row to start at:
'need to find last row of data from manifest (not resources)
last_row = Cells.SpecialCells(xlCellTypeLastCell).row
For a = last_row To 1 Step -1
Set current_cell = wksht.Cells(a, 2)
If Len(current_cell.Value) > 0 Then
end_row = a