Replies

This works great.

thanks

This works great.

thanks

Thanks Hans this site is great.

Lance

Thanks Hans this site is great.

Lance

This also works

thanks

Hans,
This is exactly what I was looking for, it works.

thanks again to all

That is done but the last cell entry keeps changing and it would be necessary to update the name. Can the naming of the last cell be dynamic?
Hope I was clear if not let me know.
thanks

You may desire to replace the error with a blank. This is done through File, Page Setup, Sheet, then go to the Cell errors as: and click on the down button to select Blank. While this will replace the error with a blank the error is still there.

Hope this helps

The previous version that I used was Office 2000 with W2000 and I believe that the settings did stick (hope my memory does not fail me on this). In any case, hope someone can either explain or provide a solution.
thanks

thanks will look at those
and thanks again for the quick response.

I guess I just have to keep the same instance when copying sheets.

thanks again

Thanks again to you, Andrew, and Steve. I did get 1 and not 1.5 as I earlier indicated (duh).

Andrew
This works great. It was so simple, guess I could not figure it out (duh) and thanks also to Hans.

Hans,
The formula =int((c1+a2)/8) results in 1.5. It should display 8.

thanks

Big Al,
I am having problems with XP and the Office applications regarding folder views not “sticking” as well. What I wanted to know is if your solution could also solve my problem. I will state my problem below and hope you don’t mind if this appears on this post.
thanks in advance

I am having problems with the views within the folders for XP and Office Applications. First I need to have each folder view by Details (no problem there) then I need to have each Office application open to my root folders (directory) in my case it is G: sorted my Name with the folders being displayed first. Then when I click on a sub-folder, the view should be by Date with the most recent files being displayed on top. Again I can obtain those views by clicking on the Details menu. My problem is to have each view stay that way once I close the application then re-open or open another application. It appears that the last view (by date, ascending order) is what I see when either re-opening the application or opening another Office application.