Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bolding Subtotals
Excel 2003:
I was wondering if there is a way to write a macro that would bold any subtotal on a worksheet. What I was thinking of doing is have some sort of Do/Loop macro with a LEFT function where if Left(ActiveCell.Text, 9) = "=SUBTOTAL" then bold the cell. It would then search all cells in the worksheet with that condition and would look until, say, the activerow is blank (or a better cutoff if you can think of one). I work with a lot of reports and there are some who would like to use this macro, and I am the only one who would know how to run it and where to install it to make it available to others. Thanks. -- Please rate posts so we know when we have answered your questions. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bolding using VBA | Excel Programming | |||
Bolding Row from VB6 | Excel Programming | |||
Bolding when subtotalling | Excel Worksheet Functions | |||
Bolding | Excel Programming | |||
Bolding problem on Subtotals | Excel Programming |