Repeatedly highlight clusters of cells by adding grids

Hello!

IŽd like to repeatedly surround clusters of cells with grids like shown in the added file.
The range should be $B$1:$J$100 and not as shown in the file.
How do I make the program to perform this?

Does this help?

Please Login or Register  to view this content.

Great!

How could I change the line style for top bars and bottom bars?
IŽd like them to be parallell.

Regards

I'm afraid I don't understand. Can you post a sample showing the line style?

Hi again!

I mean the line style should be like in the attached file with a single line surrounding and a double line dividing every fifth row.

Try:

Please Login or Register  to view this content.

Hallo!

Your solution works out fine.
One thing remains though.
IŽd like the line drawing to begin on line 1. Now it begins on line 2. Shall I define z=1 instead of z=2 or should the code be changed in another way?

You can change z=1, and x =5. But you won't have Top Border line in row 1.

IŽm really grateful.
Your guidance has meant a lot for me in pursuing my task.

Best regards

You're welcome. Glad to help out and thanks for the feedback.