Deleting Rows (more complicated)

[bigmacneb]

I have a Macro which runs and essentially pastes data into 150 rows. However this macro is universal and therefore will have varying data between one row and 150 rows. I need a macro to delete the rows from row 150 to a specific row (but this will constantly change depending on which worksheet the macro is being applied to) How can I do this? Thanks all.

 

[Von Pookie]

Assuming you will *always* be using 150 as your last row, I believe this should work?

Sub test()
Dim FirstRow As Long

FirstRow = Range("A150").End(xlUp).Row + 2

Rows(FirstRow & ":150").Delete

End Sub

 

[bigmacneb]

Perfect, Thank you.