Defining intermittent cell ranges on "Allow Edit Ranges" option in Excel.

[amaresh achar]

Hi,

I am trying to lock access for different set of cell ranges with different passwords.

Set of ranges (total 507 ranges) with range title "Supplier" are as mentioned below:
K23:T23
K25:T25
K27:T27
K29:T29
.
.
.
.
K1033:T1033
K1035:T1035

Set of ranges (total 507 ranges) with range title "IQC" are as mentioned below:
K24:T24
K26:T26
K28:T28
K30:T30
.
.
.
.
K1034:T1034
K1036:T1036

I am trying this to do using "Allow Edit Ranges" option in Excel.

Since these are intermittent / alternate rows, I am manually selecting the ranges in "Refers to cells" field and at some point, it stops accepting the selection.

Can anyone help me to overcome this issue...??? Or suggest a compact way of defining this type of intermittent ranges of cells for "Allow Edit Ranges" option in Excel...???

Thanks in Advance...

 

[amaresh achar]

Hi,

I am trying to lock access for different set of cell ranges with different passwords.

Set of ranges (total 507 ranges) with range title "Supplier" are as mentioned below:
K23:T23
K25:T25
K27:T27
K29:T29
.
.
.
.
K1033:T1033
K1035:T1035

Set of ranges (total 507 ranges) with range title "IQC" are as mentioned below:
K24:T24
K26:T26
K28:T28
K30:T30
.
.
.
.
K1034:T1034
K1036:T1036

I am trying this to do using "Allow Edit Ranges" option in Excel.

Since these are intermittent / alternate rows, I am manually selecting the ranges in "Refers to cells" field and at some point, it stops accepting the selection.

Can anyone help me to overcome this issue...??? Or suggest a compact way of defining this type of intermittent ranges of cells for "Allow Edit Ranges" option in Excel...???

Thanks in Advance...

If there is any limitation w.r.t string length in "Refers to cells" field, then solution with VBA is also most welcome...