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

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

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

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.

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

Sorry to hear about your misfortune...I will enter a new post as I have not
had any other hits on the one 'Filling Cells'. I will call it 'Numbering
Worksheets' and if you get your stuff back together maybe you can look at
it...Thanks for all your help thus far.

"Dave Peterson" wrote:

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

I had to reformat my harddrive today and lost
a lot of stuff--and have to reinstall everything I can think of (sigh).

It hurts just to read this, my sympathies!
Not due an Excel related problem, I hope.

Regards,
Peter T

"Dave Peterson" wrote in message
...
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,
<snip