• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
XL - Certain text to bold?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

XL - Certain text to bold?


  • Subject: XL - Certain text to bold?
  • From: Jay Young <email@hidden>
  • Date: Sun, 10 Nov 2002 15:29:24 -0600

Does anyone know if it's possible to change the text style only on
certain words in a cell in Excel with AppleScript?

For example, let's say in cell A1 I have this:

The sky is very blue today.

I would like to leave all the text the same, but I'd like to make 'sky'
bold. So I've tried running this code:

--------------------------
tell application "Microsoft Excel"
set Cell "r1c1"'s Characters 5 thru 7's Font's FontStyle to "bold"
end tell
---------------------------

But instead of making 'sky' bold, it makes every word bold.

I could make a Macro with VBA and then have AppleScript run that, but
does anyone know if there's another way?

Thanks!

Jay
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.

  • Prev by Date: Re: Finder selection in column view
  • Next by Date: 'Applescript-Users you have a greeting card from .
  • Previous by thread: Re: TIDs Inquiry
  • Next by thread: Re: XL - Certain text to bold?
  • Index(es):
    • Date
    • Thread