I think it's time to start over and explain what you mean one more time.

Maybe someone else will jump in. I had to reformat my harddrive today and lost
a lot of stuff--and have to reinstall everything I can think of (sigh).



jnf40 wrote:

Dave,

I forgot to add that if another worksheet was created later and it's name was
DBL ARROW (3) then
DBL ARROW cells would change to Sheet 1 of 3...
DBL ARROW (2) cells would change to Sheet 2 of 3...and
DBL ARROW (3) cells would be Sheet 3 of 3.

I hope between the two of these posts I have explained what I am trying to
do a little better.

"jnf40" wrote:

Dave,
I know there was an answer at the 'Filling Cells' post but it wasn't what I
needed...the code Moon gave actually names the sheets 1 of 2 and 2 of 2. I
didn't explain myself too well I don't guess.
My sheet names are fine as they are with the cell entry, the code you helped
me with...where i need the sheet 1 of 1 is in cells in the worksheet. On the
worksheet itself I have a cell with 'Sheet' in it then a blank cell named
Sht_of_ , the next cell has 'of' in it then a blank cell named
Sht_of_1...Looks something like this,
Sheet_____ of _____...I want the numbering to go into these cells named
Sht_of_ and Sht_of_1...So if I have 2 worksheets named DBL ARROW and
DBL ARROW (2)...then worksheet DBL ARROW would have Sheet 1 of 2 and
worksheet DBL ARROW (2) would have Sheet 2 of 2... I hope this explains it
better.

--

Dave Peterson