Thanks Don,
Because I have formulas that run down the sides and in between Values
(Values can vary between 1000 to 2800 rows and the formulas run down to 3000
rows, I need the code to delete (All) the rows from 10 rows below the values
that sits in column "K".
Reason I need the code:
Template picks up data from another workbook, then saves as something else,
the code then tidies up (Deletes excess rows) close, re-opens to start the
process over again. I have tried the delete one row at a time option but end
up waiting forever. By using the Clear instead of delete, made it a bit
faster but the file is still left with Ranges that run down to the 3000th
row, thats why I need the code to delete in bulk.
Regards
John


"Don Guillett" wrote:

Always best to fully explain.

Say col B??
clear all rows from 11 to 30 if 30 is the last row, or 29 if 30 is the last
row
OR, clear only blanks in that area

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JohnUK" wrote in message
...
Hi, Can anyone help with this. I need a piece of code that can delete all
rows in one swoop, working from the last/end row to the 10th row below a
given column with values in it. I hope I explained that okay. Help greatly
appreciated
John