How aboutVBA Code:Sub obiwan() Range("B" & Rows.Count).End(xlUp).Offset(-4).Resize(5, 15).Select End Sub
How would I code it if I want to select columns A,B & C?YupVBA Code:Range("A" & Rows.Count).End(xlUp).Offset(-23).Resize(24).Select