A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

anonymous

  • 5 years ago

Which is the most efficient way to make a row of text bold in every worksheet in a file?

  • This Question is Closed
  1. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    use VBA

  2. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Something like: Dim sheet As WorkSheet For Each sheet In ActiveWorkbook.Sheets sheet.Rows(1).Font.Bold=True Next sheet

  3. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    you can do the same from C# code too

  4. carlsmith
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Are you being precise when you say "most efficient", or do you just want an easy way to get it done? There's loads of ways you can parse a string.

  5. carlsmith
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    What do you mean by worksheet? If it's some kind of plain text file, a program or some markup or something, it's simple enough. You need to be able to define which bits to modify, which will boil down to being able to define some pattern or condition for the computer to work with. It might be simple. If it's only the top lines you need bold, you'd do everything from the start of a worksheet, up until the first newline. You might have do something more sophisticated, see regular expressions, but it's not hard to do what I think you want to do. I'm not sure what you mean by each worksheet in a file?

  6. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    look at her previous questions - i guess "spreadsheet" means Excel spreadsheet in this case "row of text" should mean a row of cells filled with some text unfortunately guys here rarely specify exactly what they want... compare with http://stackoverflow.com - that's the way how adults do it :)

  7. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    sorry, "wroksheet", not "spreadsheet"

  8. carlsmith
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Ah, now I understand. Thank you kol. I thought it might have been some kind of markup based, document format or something. I thought 'row of text' meant a line. Nice one for deciphering that for me.

  9. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    anytime :)

  10. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    im trying to find the answer to this now but i cant seem to find the answer !

  11. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.