This is where my code is failing and I know it's the syntax, but I'm not sure what to change. I've searched all over and found various types of syntax, but none seem to work. I'm sure it's likely something simple, but I'm not seeing it. I want it to search for the last used cell in the column, go to the next empty cell in the column, and put the selected range of data into it. I have multiple spreadsheets to search through that will keep adding to it ("i" is cycling through them).


Set wbkCS = Workbooks.Open(strCutSheetFile(i))
        On Error GoTo 0
    If Not wbkCS Is Nothing Then
        With wbkVer.Sheets("Cutsheets")
            Range("A" & Rows.Count).End(xlUp).Row.Value = wbkCS.Worksheets("Cut Sheet").Range("S4:S2000").Value

I get 424 and 1004 errors (depending on how I tweak the line).

Thank you!