change macro canc - step

[max_max]

Hello to all.
I ask for help to change the attached macro.
Canc step 51

-----------------------------
'N1 TO N5 = NO canc
'N6 TO N57 = YES canc
-----------------------------

from line 58 step 51
3 no canc - 51 canc

'N58 TO N61 = NO canc
'N62 TO N113 = YES canc
'N114 TO N117 = NO canc
'N118 TO N169 = YES canc
ETC
ETC
ETC
------------------------------

Please Login or Register  to view this content.

I hope I explained myself.
max_max

[Leith Ross]

Ciao max_max,

Ho fatto modifiche al codice. Testare la macro e mi dicono i risultati.

Please Login or Register  to view this content.

[max_max]

Hello leith ross.
I think it's perfect.
Thank you so much.
A greeting.
max_max
----------------------
Ciao leith ross.
Penso sia perfetto.
Ti ringrazio tantissimo.
Un saluto.
max_max

[Keebellah]

A tip:

If you protect a worksheet, you can use the following code:

Please Login or Register  to view this content.

This extra parameter (bold red text) does NOT allow a user to change the contents of a blocked cell but a macro can modify everything.
This makes it unnecessary to unprotect a worksheet and then protect it again.

Only if you edit a macro and make changes to the code you will first ahve to protect the sheet again using the macro so it 'remembers' that UserInterfaceOnly = true