Replies

Hi Legare,

Thank you for your reply. Your code worked like a charm. I was able to integrate it into the larger macro without problem.

Besides solving the problem it was instructive to me on a couple of levels, as your code often is.

Thank you again.

Hi Hans,

Thank you for your reply.

Actually, I did that but that didn’t work either. It kept stopping at that line unless I selected the specific worksheet. I can send the entire macro if you’re interested…

Hi Hans,

Well, I knew that if anyone had the answer, it would be a Woody’s regular. Thank you kindly and thank you very much for your detailed and clear explanation.

Regards,

Hi Hans,

Well, I just tried your combination and it works. Next I decided to put the two formulas together and I got that to work as well…

Hi Hans,

Good suggestion. I am not in front of that file right now, but I will try your suggestion first thing in the morning.

I was hitting a wall with this formula. I finally had to give up and go to the pros…

I’ll let you know how it works…

Thanks again…

Well, given that I’ve gotten so much use from your free utilities, I would feel that it would be both shortsighted and, yes, cheap of me not to at least inquire further.

Of course, both price and the scope of the utility will be factors, but please let me know more…

Regards,

Hi Jan,

I will try the HTML approach; great suggestion.

And if I could get your utility I would be in heaven. It is murder manually changing 75 or 100 names only to have Excel crash before I can save (or if I forget to save).

Thank you for all the great stuff you do in the Excel world…

Hi,

Thank you for your response.

Unfortunately, I work in an environment (large financial instution) where such files are commonplace. I use Jan Karl Peterse’s magnificent Name Manager regularly to ferret out the thousands of names I see regularly. In fact, when I was a consultant I found that to be true in many similar institutions.

I have seen all too many files with styles that have similar and weirder names, and similar numbers of custom number formats.

And it generally isn’t feasible to copy the worksheets as you suggest for a number of reasons: some books have more than 50 sheets, some have links that point within and without, some have very hidden sheets created by third-party add-ins, etc.

It’s a MAJOR headache that Microsoft refuses to acknowledge.

Legare, it worked like a charm, with the small exception that when the last worksheet was reached, the variable oWS produced an error. So I added an ON ERROR line in front of the loop.

Thank you very much for your assistance. The Excel world would be a poorer place without you and your colleagues.

Thank you very much, Legare. This looks exactly like what I’m trying to do.

I will give it a shot and get back to you shortly.

Thanks again.

I have not checked that but I will.

But wouldn’t that setting also affect Word?

I should’ve mentioned that I tried both of those approaches. I started Excel in safe mode and I tried all the installed printers, all to no avail. I also opened Word and created a table, no problem in the Word table

Hi Hans,

Great solution. I don’t know why the thought of creating a column of the added numbers eluded me, but it did. Thankfully, it didn’t elude you.

Thanks once again for a nice insightful solution…

Regards,

Hi Hans,

Thanks for the quick response.

I will give your suggestion a try as soon as I can pin down the user. She’s been unavailable so far today. I’ll let you know how it comes out.

Thanks again…

Hi Hans,

Thanks for your reply. I had been trying to create a comprehensive formula that would work but when I saw your solution I thought that maybe I should just go with that, as it worked. However, my procrastination in checking back here had a benefit for me, in that Maxflia came up with a formula that works for me.

I do very much appreciate your efforts and the efforts of everyone on this board. You all do a world of good and you provide the court of last resort, so to speak, when there is no one else to take on complex problems. I have been saved on multiple occasions by the experience, insight and willingness to share of those on this board.

Best regards,