having the same name for a lst, on multiple sheets
 

Is it possible to have the same name for my database list on multiple
sheets.

Could someone show me the correct syntax to do that through VBA please.

Say the name I want to add is "Database" and I want to add it on a sheet
named "Retail" and a sheet named "Hotel"

Thanks, Eric

having the same name for a lst, on multiple sheets
 

Worksheets("Retail").Range("A1").Name = "Retail!Database"

or:

ActiveSheet.Range("A1").Name = ActiveSheet.Name & '!Database"

etc.

--

Vasant


"Eric" wrote in message
nk.net...
Is it possible to have the same name for my database list on multiple
sheets.

Could someone show me the correct syntax to do that through VBA please.

Say the name I want to add is "Database" and I want to add it on a sheet
named "Retail" and a sheet named "Hotel"

Thanks, Eric