Create the named range with the sheet name in front of the name something
like this...

Sheet1!MyCell
and
Sheet2!MyCell

--
HTH...

Jim Thomlinson


"Chris" wrote:

I am trying to create the same cell name on multiple worksheets within a
workbook and having difficulties. I know this can be done by creating the
cell names on a single worksheet and then copying that worksheet but this is
a long way around if you just want to add one duplicate name. If I have an
existing cell name on Sheet1, how can I duplicate that cell name on Sheet2?
I'm using the Indirect function to get data from multiple worksheets that
have the same names. Thx.