Ive got a table of 20 rows (row numbers vary). i need to select the
last 10 rows (fixed amount) of data and delete all above it.

ive used

x = UsedRange.Rows.Count
y = totalrows - 10

but when i try

Rows("1:y").Select

to select the rows above the 10 i need it brings up an error, but if
i were to replace the "y" with a row number it works fine, ie Rows
("1:5").select.