Names of workbook cell ranges not accepted with some signs
 

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 ValidationList =S1:CR1. In B1 i use
ValidationList =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 InsertNameDefine(select one)Delete.

Thanks,
zzxxcc

Names of workbook cell ranges not accepted with some signs
 

One typical name is: Wrench with 1/2" square attachment.
--
Thanks


"zzxxcc" wrote:

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 ValidationList =S1:CR1. In B1 i use
ValidationList =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 InsertNameDefine(select one)Delete.

Thanks,
zzxxcc