-
WScatoothaker
AskWoody LoungerThanks! That works great.
–cat -
WScatoothaker
AskWoody Loungerhmmm … not till Excel 2002?
-
WScatoothaker
AskWoody LoungerThanks!!! That was it!
–cat -
WScatoothaker
AskWoody LoungerThanks, both of you. I will let you know –cat
-
WScatoothaker
AskWoody LoungerThanks, Sam. I discovered that this particular Excel file was part of the DaCS for MS Excel (for 21 CFR Part 11 compliance), so many Excel functions don’t work the way they are supposed to. –cat
-
WScatoothaker
AskWoody LoungerThanks, John, for your time.
–cat -
WScatoothaker
AskWoody LoungerSorry … we use Windows 2000 and Office 2000 throughout. I did use the email button — this works, but it sends the entire sheet. I need just a selection. Our default settings are RichText. I used the typical copy/paste (CTRL-C and CTRL-V) commands. I can receive a sender’s email that includes a pasted excel selection. I can copy/paste Word selections into Outlook, too. Which is the work-around that my IT guys came up with. Copy/Paste from Excel to Word, then Copy/Paste into Outlook … hmmm. I’ve, also, tried using the command, Copy Picture, from the Edit menu (this shows up when I hold down the Shift key before clicking on the Edit menu). This, too, doesn’t work.
Again, thanks.
–cat -
WScatoothaker
AskWoody LoungerThanks, Legare. I had written “Brute Force” code, but it covered more area than I needed and was time-consuming. I do appreciate your help.
-
WScatoothaker
AskWoody LoungerHi Legare. I am sorry. I did not give all the information. I have a value in cell AA1 that will dictate how many cells in column B (starting at B9) that need to be formatted in this fashion.
It is the looping that I do not understand. I will need to loop through cells B9 until B??, depending on the value in cell AA1, and keep track of the lengths stored in the corresponding columns K, L, and M.Any more help would be greatly appreciated.
-
WScatoothaker
AskWoody LoungerThanks Andrew
-
WScatoothaker
AskWoody LoungerThanks Wassim, … again, you have been very helpful!
-
WScatoothaker
AskWoody LoungerThanks Rory and Wassim,
I ended up using this formula in a new column:
=IF(ISERROR(FIND($B$1,E1)+FIND($B$1,J4)),0,1)
The user then enters the word or phase in Cell B1, clicks on a macro button which filters on this hidden column for the 1s.
Again, thanks.
-
WScatoothaker
AskWoody LoungerHi Wassim,
ummm, say “Hi” to Sebastian for me. Whose Sebastian?
Yes, this will work great. I had tried to concatenate the two columns into another column, but one of the columns was pretty wordy — so, this was changing the rowheights causing the spreadsheet to not look too pretty. I like your method better.
Thanks. -
WScatoothaker
AskWoody LoungerSorry, HP. I thought the original post was “too general” and that no one would help me then. I am now trying the WorkSheet_Calculate event. Thanks again.
-
WScatoothaker
AskWoody LoungerThanks, Andrew and Rory, … I need the formula so I’ll live without or work-around the Bold issue.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Seeing BSOD’s on 24H2?
by
Susan Bradley
1 hour, 40 minutes ago -
TUT For Private Llama LLM, Local Installation and Isolated from the Internet.
by
bbearren
5 hours, 6 minutes ago -
Upgrade from Windows 10 to 11
by
Holdsworth8
7 hours, 30 minutes ago -
Microsoft : AI-powered deception: Emerging fraud threats and countermeasures
by
Alex5723
10 hours, 20 minutes ago -
0patch
by
WSjcgc50
6 hours, 48 minutes ago -
Devices might encounter blue screen exception with the recent Windows updates
by
Susan Bradley
3 hours, 42 minutes ago -
Windows 11 Insider Preview Build 22631.5261 (23H2) released to Release Preview
by
joep517
13 hours, 19 minutes ago -
Problem opening image attachments
by
RobertG
14 hours, 54 minutes ago -
advice for setting up a new windows computer
by
routtco1001
1 day, 5 hours ago -
It’s Identity Theft Day!
by
Susan Bradley
9 hours, 56 minutes ago -
Android 15 require minimum 32GB of storage
by
Alex5723
1 day, 10 hours ago -
Mac Mini 2018, iPhone 6s 2015 Are Now Vintage
by
Alex5723
1 day, 10 hours ago -
Hertz says hackers stole customer credit card and driver’s license data
by
Alex5723
1 day, 11 hours ago -
Firefox became sluggish
by
Rick Corbett
1 day, 8 hours ago -
Windows 10 Build 19045.5794 (22H2) to Release Preview Channel
by
joep517
1 day, 15 hours ago -
Windows 11 Insider Preview Build 22635.5235 (23H2) released to BETA
by
joep517
1 day, 15 hours ago -
A Funny Thing Happened on the Way to the Forum
by
bbearren
12 hours, 46 minutes ago -
Download speeds only 0.3Mbps after 24H2 upgrade on WiFi and Ethernet
by
John
7 hours, 20 minutes ago -
T-Mobile 5G Wireless Internet
by
WSmmi16
13 hours, 27 minutes ago -
Clock missing above calendar in Windows 10
by
WSCape Sand
14 hours, 39 minutes ago -
Formula to Calculate Q1, Q2, Q3, or Q4 of the Year?
by
WSJon5
2 days, 6 hours ago -
The time has come for AI-generated art
by
Catherine Barrett
1 day, 10 hours ago -
Hackers are using two-factor authentication to infect you
by
B. Livingston
1 day, 20 hours ago -
23 and you
by
Max Stul Oppenheimer
2 days, 3 hours ago -
April’s deluge of patches
by
Susan Bradley
7 hours, 12 minutes ago -
Windows 11 Windows Updater question
by
Tex265
7 hours, 33 minutes ago -
Key, Key, my kingdom for a Key!
by
RetiredGeek
3 days, 12 hours ago -
Registry Patches for Windows 10
by
Drcard:))
3 days, 16 hours ago -
Cannot get line length to NOT wrap in Outlining in Word 365
by
CWBillow
2 days, 23 hours ago -
DDU (Display Driver Uninstaller) updates
by
Alex5723
2 days, 8 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.