Deleting a specific grouping of cells with variable sizes

[kinakin]

Hi everyone,

I am looking to see if it is possible to add a macro to the attached workbook that can delete what I've called a Scope Group.

Scope Breakdown 01.PNG

For quick reference in the picture, what I would like to do is add a button that will delete an entire Scope Group, as well blank white line below, so it doesn't disturb the aesthetic. The issue with this is that the group can vary in size from as small as 1 line to as large as 200.

Thanks!

[KOKOSEK]

Navigating on protected sheet is very uncomfortable.

[kinakin]

Sorry about that. The password is 388158010. You can see these in the macros too.

[LJMetzger]

Hi kinakin,

Try the following Macro which is included in the attached Workbook. I commented out all Sheet Protection.

To use the Macro, Select a Brown 'Scope Group' Header Row and then Select the Delete 'Scope Group' CommandButton.

The following code is in Ordinary Code Module ModDeleteScopeGroup:

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). https://www.excel-easy.com/vba/examp...-explicit.html

Lewis

[kinakin]

Hi LJMetzger

This is a great start and does exactly what I looking for. I wonder though if there is a way to bypass the need to select the Scope title and have it reference the cell the button would be in instead, similar to how the Add Line macro works. I ask because I would like to put a Delete Scope Group button on each separate scope, similar to how the Add Line button is.

Please Login or Register  to view this content.

[LJMetzger]

Hi,

Your idea fits much better with the design than my implementation. Well done.

I deleted my CommandButton and put 'Delete' icons in Scope Groups 2,3, and 4. Clicking the 'Delete Icon' will delete that 'Scope Group'.

See the attached file (most of the code is the same) containing the modified code below (much simpler now):

Please Login or Register  to view this content.

Lewis

[kinakin]

That's perfect! I really appreciate the help on this.