Dave Peterson...
 

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...
 

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 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 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.

Dave Peterson...
 

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

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

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

Dave Peterson...
 

I don't think it was excel.

I thought that it was a hardware problem, but now that I'm back up (almost), I
googled for the error message that I got.

It looks like there was some caching problem while writing to the harddrive.
One of the suggestions was to slow down the writing (IIRC). But the pc worked
fine for the last 18 months. I did install some other software and I've got a
feeling that it may have been one of those programs.

But it's just my gut feeling--so I might be jumping to conclusions.

And since I couldn't get to the internet to google for hints, I was stuck.

I wouldn't suggest ever doing this, but reformatting and reinstalling only the
software I use sure makes my pc boot up quicker and shut down quicker.



Peter T wrote:

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

--

Dave Peterson

Dave Peterson...
 

A salutary lesson for us all Dave. Guess I ought try and retrain my belief
that this kind of thing only ever happens to someone else!

Regard,
Peter T

"Dave Peterson" wrote in message
...
I don't think it was excel.

I thought that it was a hardware problem, but now that I'm back up
(almost), I
googled for the error message that I got.

It looks like there was some caching problem while writing to the
harddrive.
One of the suggestions was to slow down the writing (IIRC). But the pc
worked
fine for the last 18 months. I did install some other software and I've
got a
feeling that it may have been one of those programs.

But it's just my gut feeling--so I might be jumping to conclusions.

And since I couldn't get to the internet to google for hints, I was stuck.

I wouldn't suggest ever doing this, but reformatting and reinstalling only
the
software I use sure makes my pc boot up quicker and shut down quicker.



Peter T wrote:

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

--

Dave Peterson

Dave Peterson...
 

Well, I know that that's the way it's supposed to work <bg.



Peter T wrote:

A salutary lesson for us all Dave. Guess I ought try and retrain my belief
that this kind of thing only ever happens to someone else!

Regard,
Peter T

"Dave Peterson" wrote in message
...
I don't think it was excel.

I thought that it was a hardware problem, but now that I'm back up
(almost), I
googled for the error message that I got.

It looks like there was some caching problem while writing to the
harddrive.
One of the suggestions was to slow down the writing (IIRC). But the pc
worked
fine for the last 18 months. I did install some other software and I've
got a
feeling that it may have been one of those programs.

But it's just my gut feeling--so I might be jumping to conclusions.

And since I couldn't get to the internet to google for hints, I was stuck.

I wouldn't suggest ever doing this, but reformatting and reinstalling only
the
software I use sure makes my pc boot up quicker and shut down quicker.



Peter T wrote:

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

--

Dave Peterson

--

Dave Peterson