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" wrote:

You have a response at that thread.

jnf40 wrote:

Could you look at the posts I have under 'Filling Cells' and also there was a
follow up question for you from my post 'Finding Worksheet'.

Thanks

--

Dave Peterson