Macro required to delete row numbers specified on another worksheet

Hi,

Hoping someone can help me please to improve a macro I currently have. At the moment, my macro uses this code:

Please Login or Register  to view this content.

Fairly simple, but the problem is that the rows that need to be deleted may change over time. To get around this, I've got a seperate sheet in my workbook called 'macro controls'. In this sheet, cell C3 has the value 1, and cell E3 has the value 9.

what I want my macro to do, is to check the values in these 2 cells, and then delete these rows in the sheet called 'sandpit'.

Any help please?

Thanks a bunch.

Hope this helps...
I considered sheet which contains value in C3 and E3 as Sheet2

Please Login or Register  to view this content.

Thanks Abdul. I think that's nearly there, but the macro above only deletes cells A1-I1 (because value V1 = 1 and V2 = 9). What I actually want it to do is delete rows 1-9 entirely.

Use this....

Please Login or Register  to view this content.

Perfect. Thank you so much!

Thanks for your feedback....Please mark this thread as Solved....


Abdul-