Naming cells

W

Watercolor artist

I have a file with multiple worksheets. In one of the sheets, I named a cell
"Company." In another sheet, I tried to give a cell the same name. But it
seems you can have two cells in different worksheets with the same name. Is
there any way to do that?

Howard
 
V

Van T. Dinh

Yes you can have the same name for named Ranges in different Worksheets.

To refer to a named Range on a different Worksheet, you need to included the
Worksheet name in the reference.

Check Excel Help on the Worksheet reference and if you can't work it out,
re-post to one of the appropriate newsgroups for Excel.
 
Top