Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #15  
Old 11-05-2013, 08:05 PM
BobBridges's Avatar
BobBridges BobBridges is offline How to remove auto type entry Windows 7 64bit How to remove auto type entry Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Quote:
Originally Posted by ep2002
LOL, you went right over my head with your formulas, thank gawd your last sentence was in English . Ok, so I searched the workbook & checked off case & searched both rows & columns separately & nothing....
<Chuckle> Ok, forget my long-winded explanations and let's try it this way. Go back to the workbook and:
  • Start a Find (<Ctrl-F>).
  • In the expanded Options menu, put 'cJ' (mixed case) in the "Find what:" text box.
  • Check the "Match case" option (and by "check" I mean turn it on).
  • Make sure the "Match entire cell contents" option is off.
  • Set "Within:" to "Workbook".
Now do two different searches, one with the "Look in:" option set to "Formulas", and again with it set to "Values" (but with all the above options as described).

As I said before, I'm reaching. But then at this point we're all scratching our heads unsure of what's going on, right?, so maybe I'm a genius and maybe I'm just wasting your time on another unlikely hypothesis, but either way it probably couldn't hoit.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a Main category mirrored in Sub category data entry type of solution? Geza59 Excel 0 10-19-2012 05:44 AM
Outlook 2003, Modify default "entry type" for new journal entries narichardson Outlook 5 03-14-2012 08:34 AM
Can Word auto type text for me? paddyirishman05 Word 1 08-28-2011 01:30 AM
Auto Entry Names etc Into Document simonyglog Word 2 07-08-2010 10:22 AM
Auto entry of email address (who I'm sending to) Miket Outlook 5 12-10-2008 04:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft