Make a range dynamic for edition!

Gents,

Recently I was wonderfully replied in a post called "Restrict VBA execution to a range o cells!".

Shortly explaining, I wanted to restrict the use of a few macros to a certain range C28:I32 that constitutes a "section". The macros include adding, copying and deleting lines where the cells are selected within this section. I cannot allow these macros outside this section or all hells break loose but I eventually need these macros to take action on this section after new addition or deletion of lines (e.g. C28:I34 or C28:I31).

In fact, what I needed was that this section was C28:I?? where the I?? cell corresponds to what initially is I34 minus 2 cells up.

HTML Code: 

How can I make this section "dynamic"! I've been trying with named ranges and offset but unsuccessfully.

Regards,


Ricardo

Hi Ricardo

Please attach a sample workbook the Structure of which is the same as your actual workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.