Z
zzxxcc
I have named a range of cells based on the top row in each column. S1:CR20.
Some names need signs like"/" and "-" and """, etc. This doesen work with
conditional validation. In A1 i use Validation>List> =S1:CR1. In B1 i use
Validation>List> =indirect(A1) and conditional formating. Is there a way to
make this work? I mean: To make Excel accept the different signs.
Also is there a way to delete all names in the workbook in one operation? I
am familiar with Insert>Name>Define>(select one)>Delete.
Thanks,
zzxxcc
Some names need signs like"/" and "-" and """, etc. This doesen work with
conditional validation. In A1 i use Validation>List> =S1:CR1. In B1 i use
Validation>List> =indirect(A1) and conditional formating. Is there a way to
make this work? I mean: To make Excel accept the different signs.
Also is there a way to delete all names in the workbook in one operation? I
am familiar with Insert>Name>Define>(select one)>Delete.
Thanks,
zzxxcc