Making range delete code more efficient

Hello everyone,

I would appreciate some help with making the following code more efficient (got it online). It works as it is but I have two issues with it that I can't seem to solve:



1) I can't seem to be able to replace this code

Please Login or Register  to view this content.

with something more flexible like the following. Am I doing something wrong or is it the way the macro is made that prevents this change?

Please Login or Register  to view this content.

2) I read that structuring a range reference in the following way was "frowned upon." Why is that and how do I improve this?

Please Login or Register  to view this content.

If there is anything else you see that can improve the code, please let me know. The entire code is below.

Please Login or Register  to view this content.

Thanks!

Geoff.

Certainly this can be modified..just attach your spreadsheet with some data on it.

Regards,

Hello BS Singh, thank you for taking the time to help me out.

Here is the file that I was testing this code on: del_range.xlsx

I made a slight change in the code so here it is again:

Please Login or Register  to view this content.

Regards,

Geoff.

Hi Geoff,

This should work for you:

Please Login or Register  to view this content.

This will compare the value of column P with value you will enter in Cell S1 and if match found then will delete the cells from M and P column.

The comparison will take place from top to bottom rather then bottom to top. I hope this is not an issue.

Regards,

Hello BS Singh,

Apologies for the delay in responding, I thought no replied has come in on this thread.

Thank you for this code. I had read somewhere that going for top to bottom can be an issue for this type of exercise because the code might skip over the row just beneath the one that was found to match the criteria. I'm not sure if this is clear, if so, do you know if this is an issue in this case?

Thanks,

Goeff