Replies

Wow! What a great function. You have no idea how much time you have saved me. Many many thanks.

I’m happy with your array – it works! Thanks again for your time.

Your suggestion works – thank you!
I am not familiar with arrays, but I seem to remember hearing that large arrays can be very slow to calculate. Will it matter if the array has two columns but perhaps several hundred rows?

Thanks for your response. Our IS people have looked at this with no luck. It definitely seems to be a problem with individual computers, not the templates. If I create a new Word document and insert a check box using the Forms tool bar, the check box always work and never crashes. Some other computers who try to create check boxes in Word – or use the new documentsI have created – still crash immediately when they double-click the check box. Can you expand on your comment about “changing the field properties” – I don’t understand. Thanks.

Thanks for the reference to the previous discussion. I am inclined to believe that, as someone pointed out, that this is a “known issue” without a good solution. I have managed to work around it by manipulating font size, etc. as recommended. Per your suggestion, I am attaching an earlier version of the document where I discovered the problem. Again, thanks for your help.

The SumProduct function solves my problem! Thanks to everyone for their helpful comments.

It works! Thanks very much for your help.

Oh well, so it goes. Thanks very much for your reply – this forum and the people on it such as yourself are an incredible resource.

I have read your suggestion to this problem, but I don’t think it quite applies to what I typically need to do. I’m usually hyperlinking from a base Word document to a secondary Word document whose file name I don’t know – I have to browse to find it. And I want both documents – or a whole string of them – to remain open. Someone showed me the following method, which is incredibly laborious, but does work. Any suggestions on shortening this process? Thanks.

 Select the word or phrase that will serve as the hyperlink (and remember what it is)
 Insert > Field
 Hyperlink > Options > n > OK > Ok
 In place of the hyperlink word or phrase selected will appear the message

This worked when I did Edit, Delete, All rather than Edit, Clear, All. Thanks very much – this was driving me crazy.

Thanks for the responses. The IF statement worked perfectly.

Phil, your macro works perfectly. Thanks very much!

Your suggestion worked perfectly. Thanks very much.