Equal Range names allowed?

[Jan Lichtenbelt]

Are equal Range names allowed in different worksheets?

Kind regards

Jan (John)

[NeedForExcel]

Equal?? Do you mean same??

Yes they are allowed, however, you will have to define the the Range Name Scope to that that particular worksheet, instead of workbook.

You can goto Formulas Tab > Define Name > Scope and select the worksheet you want the name to be in.

[Jan Lichtenbelt]

Thanks a lot. I will try it.