Macro to be deactivated in specific ranges

Hello,

I have 2 questions about the below Macro:

1) Why the below part doesn't work in my current macro??

HTML Code: 

2) would it be possible to define like 3 ranges (with name manager. eg: "range1" "range2" "range3") and indicate the range in the macro to NOT have the macro running in these ranges (example: 12:26 = range1 / 56:56 = range2 / 76:76 = range3)

Please Login or Register  to view this content.

Many Thanks,
Graig

Hi Graig,

Your requirement is that - as you delete the row numbers changes and may be losing important numbers or formulas without knowing.
Below code works in the dynamic way as you select any row within the named ranges, it doesn't carry out the delete operation. If it is outside the defined ranges it carries out the delete row operation.

Please Login or Register  to view this content.

Thanks & regards,
Lokesh

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Hello lokicl,

From the clarification you have put in your answer it really reflect what I need! I tried out the macro but I got the error message attached.

I really don't get how I could get that message as I only specify 3 range name and it seems like the macro tell not to run the macro inside the range...

Can you please help?

Hello Holger,

I haven't tried your macro. But I am afraid that if I do not define range I will have problem.. as lokicl said if I delete the row numbers changes and may be losing important numbers or formulas without knowing...

Hi Graig,

I am unable to see the error message. Please reupload again.

Regards,
lokicl

hello romperstomper!

It works well and exactly the way I needed to have it working

Many Thanks,
Graig