Names of workbook cell ranges not accepted with some signs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top