anonymous
  • anonymous
Which is the most efficient way to make a row of text bold in every worksheet in a file?
Computer Science
katieb
  • katieb
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.

Get this expert

answer on brainly

SEE EXPERT ANSWER

Get your free account and access expert answers to this
and thousands of other questions

anonymous
  • anonymous
use VBA
anonymous
  • anonymous
Something like: Dim sheet As WorkSheet For Each sheet In ActiveWorkbook.Sheets sheet.Rows(1).Font.Bold=True Next sheet
anonymous
  • anonymous
you can do the same from C# code too

Looking for something else?

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

More answers

carlsmith
  • carlsmith
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.
carlsmith
  • carlsmith
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?
anonymous
  • anonymous
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 :)
anonymous
  • anonymous
sorry, "wroksheet", not "spreadsheet"
carlsmith
  • carlsmith
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.
anonymous
  • anonymous
anytime :)
anonymous
  • anonymous
im trying to find the answer to this now but i cant seem to find the answer !

Looking for something else?

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