last row vba

[orsm6]

hi all, the code below runs well, but wanted to see if i could omit the "range(K16:q1000)" part of the code.
in every instance i need to select K16 first and then to the last row of column Q. minus one row if possible

i tried rows.count -2,1 but i imagine this just goes to row 998

 Application.ScreenUpdating = False
    Sheets("Table").Select
    With Sheets("Table")
        .Range("K16:Q1000" & .Cells(Rows.Count, 1).End(xlUp).Row).Select
    End With
    Selection.Copy

tia.

 

[mrshl9898]

Try:

    With Sheets("Sheet2")
        .Range("K16:Q" & .Cells(Rows.Count, 17).End(xlUp).Row - 1).Select
    End With

rows.count, x is the number of the column you are counting.

 

[orsm6]

ahhh of course. yeah that works just fine.

thank you.