Recent content by JohnCHolmes

Frink, I like your posts, communication clarity and attitude. I think you might like to look at this one too. http://www.mrexcel.com/board2/viewtopic.php?t=109378&highlight= However it relies on Microsoft's find (essentially a Ctrl-F, I believe) and is consequently slower, just the way...

Thanks, tf1 - I'm inclined to go that way. A catch would be if I inherited a huge .DOC with tons of proper names. Also thanks fumei. 1. I have no forms. 2. What I referred to was heavier than the single file Boolean. When you "ignore" a suggestion, your answer is remembered even after you...

Well, for the future, options/save/always create backup

If that's the only copy there's not much you can do. At the cost of losing formatting, justification, bold, underline, and several other things, one way you might "clean it up" is to Select All and copy to Notepad, then copy/paste back the other direction. This wouldn't get everything either...

I just saw something that I don't believe I've seen before. Upon completing a spelling/grammar check, instead of just saying "the spelling and grammar check is complete" it also added something to the effect of "sections marked for exclusion were not checked." I cannot even reproduce that extra...

Well garsh I took for granted you knew how. IMHO you really ought to have that skillset to mess with VBA. As a quick start, go tools/macro/macros, highlight yours, click Step Into. Then use F8 to step through the code. Pass your mouse over code variables to see current contents (for _some_...

Have you stepped through the code? Use the debugger. That can't possibly be less trouble than getting the solution third-hand. One of the things that debugging does is causes you to question exactly what you've ordered the code to do. Your code says "go end-down" (etal). Have you...

I have a brute force solution. I humbly defer to anyone who has the "proper" solution; but since your question is not getting any grease, I hope you'll appreciate this much, despite my personal embarassment at this banality [tongue] I don't use the correct way to communicate between...

You know, when testing these things and you have problems like this you should not suppress DisplayAlerts. Perhaps you're already beyond that point but it's generally good advice. Another useful practice is using Option Explicit, if you're not already. (It would appear not) There are...

I don't have your answer but have general advice that might lead you forward. In the barfing code highlight .Connection and hit F1. Then click on the word Connection. Then click example and choose Connection Object. I believe this will show you the format you need, although I sympathize with...

Use your good friend record macro. It will show something like .RightFooter = "Pg. &P of &N ... printed &16&D&10 &T ... tab '&A' in '&F'&""Arial,Italic""(unsa&""Arial,Regular""ved file)" Can you run with it from here?

Regarding Zathras solution: It might be preferable to eliminate the ROW clause and instead just apply the conditional formatting to only rows 57+. The potential drawback otherwise is if you e.g. delete rows 1-50, the condition will still be married to 57+, and if you then wanted the coloring...

Well done - star.

Re the handy FAQ at http://www.tek-tips.com/faqs.cfm?spid=707&newpid=707&sfid=2892 I sent the author some suggestions. This is a placeholder for him to reply if desired.

RESOLVED. Squint hard at the original question. It has "ending double quotes," not "generic double quotes." Access barfed on them. I edited the actual query -- which is a 16-legged-hairy-mother query with parentheses out the yeng-yang -- in Microsoft Word, in order to use...