Hello All Forum Users Johnnydotcom back with another problem to solve.

I have a nice Worksheet with groups running down the side, which in turn adds 4 empty rows between each part number.

I have been challenged with selecting the part numbered cells only and then require that the selected range drops down for each separate selection by 1.

Below is an example of what i would like to achieve

the left image is manually selected by a user and the right image is what happens when a macro is run.

what I use this for after this event is complex and so I will not go into detail at this stage.

at this stage i am thinking loops, offset, resize, etc.

Advanced range1.jpgAdvanced range2.jpg