A community for students.
Here's the question you clicked on:
 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?
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

anonymous
 5 years ago
Best ResponseYou've already chosen the best response.0Something like: Dim sheet As WorkSheet For Each sheet In ActiveWorkbook.Sheets sheet.Rows(1).Font.Bold=True Next sheet

anonymous
 5 years ago
Best ResponseYou've already chosen the best response.0you can do the same from C# code too

carlsmith
 5 years ago
Best ResponseYou've already chosen the best response.0Are 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.

carlsmith
 5 years ago
Best ResponseYou've already chosen the best response.0What 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?

anonymous
 5 years ago
Best ResponseYou've already chosen the best response.0look 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 :)

anonymous
 5 years ago
Best ResponseYou've already chosen the best response.0sorry, "wroksheet", not "spreadsheet"

carlsmith
 5 years ago
Best ResponseYou've already chosen the best response.0Ah, 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.

anonymous
 5 years ago
Best ResponseYou've already chosen the best response.0im trying to find the answer to this now but i cant seem to find the answer !
Ask your own question
Sign UpFind more explanations on OpenStudy
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
 Engagement 19 Mad Hatter
 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.