Search:

Is there a way to make a table of contents "interactive" such by clicking on the page numbers, word will take me to that page or section?
Thanks in advance.
Jeff

Thanks Paul and Andrew. Andrew, if I am reading your post correctly, this might be what I want to do. How do you change the default table style?

thanks geek

I have a document that in over 150 pp long. Roughly 1/2 of the document have one space after the period at the end of a sentence, and the other 1/2, two spaces. I would like to do a global search...

I have a document with in excess of 100 tables. I would like to do the following: globally change the margins of all of the current tables in the document at one fell swoop, and set the default for...

Thanks Eric.

I am working on a very large document (>250 pages) with many footnotes (>500). This is a work in progress, i. e., it will change several times before a final version is attained. During that...

1. I have a document with certain headings already "defined." When I highlight to text and try to change the heading stye, it doesn't seem to work.

2. I would like to globally change the spaces...

Thanks Steve. I was under a time constraint and didn't hear anything back. I was just getting ready to post Han's solution, but you beat me to it.
Thanks for your help.

Thanks for your reply, Kweaver. I think we almost have it, except I am looking for a "unique" counting of customers in each classification. Your formula includes duplicates in its results. ANy...

Here you go Steve

In column A i have the names of customers separated by contract types. Some customers are listed in more than one contract type. For example, column A, rows 1-35 contain the names of customers...

Is there any way to, via code, e-mail certain, but not all, worksheets in sa workbook, upon prompting by Excel of which ones?
Thanks in advance.

Posted this on Mr Excel.

I have several worksheets in one workbook entitled, "A", "B", "C", "D", and "E". In A1 of each worksheet is the title of the respective worksheet. In A3 is the word "Day",...

Maud,
Thanks again. Will these work on a range of cells say A5:A78?

Thanks Maud. Any ideas on VBA that would do the same thing (and save several keystrokes)?
Thanks,Jlkirk
Again if the cell I want to change is in text "January 2013" (or "February 2013", etc.) I...

Sorry, Zeddy, it was a misprint. It should have been convert "January 2013" to "1/1/2013".
Sorry.

I would like vba to convert date text such as "January 2013" to the following style"2/1/2013"/
Thanks in advance.

In column A I have >100 rows with each cell containing an "R" or a "D". In column B I have correnspoding numerical data (all non-negative). What I would like is vba that would put a minus sign in...

Thanks Martin, Works great!

Martin,
Works perfectly. Thanks. However, the range needs to be more flexible; sometimes it might be A5:A55, another, A7:A90, etc. Any ideas?
Thanks again.

Thanks Retired Geek and Rory. Rory, being a VBA novice, is this a complete new macro, or where do I put it?
Thanks again guys!

Hey Retired Geek,
We meet again. You almost have it (I realize I wasn't clear enough in my previous postings). I attach a file with the desired before and after effects of the macro. In a...

Any code out there that would remove all words (as well as objects such as colons or hyphens) in a range that are not all capital letters?
Thanks in Advance.

Jim,
Here is a sample of before and what I would like it to be after running the macro, etc. Column A is before and column B is after. Hope this helps.
Jeff