H
Helmut
How can I have the entire ROW in the subtotal routine BOLD?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Per Jessen
Hi
Rows(X).entirerow.font.bold=true
where X is the row number.
Regards,
Per
Rows(X).entirerow.font.bold=true
where X is the row number.
Regards,
Per
B
Bob Phillips
No need for Entirerow
Rows(X).font.bold=true
Rows is the entire row
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Rows(X).font.bold=true
Rows is the entire row
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
H
Helmut
What I have is this:
Range("A11").Select
Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(4, 5,
6, 7, _
8, 9, 10), Replace:=True, PageBreaks:=False, SummaryBelowData:=True
I don't know "X". it is determined by the above sugtotal routine. where the
subtotal row should be entirely bold.
Range("A11").Select
Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(4, 5,
6, 7, _
8, 9, 10), Replace:=True, PageBreaks:=False, SummaryBelowData:=True
I don't know "X". it is determined by the above sugtotal routine. where the
subtotal row should be entirely bold.
D
Dude Ranch
Then Helmut right an additional line of code to find the bottom row and use
the cide the boys (assumption) gave you
ie
Range("a11").select
Selection.End(xlDown).Select
X=Activecell.Row
Then use the other stuff to make bold.
Aloha
Jeff
the cide the boys (assumption) gave you
ie
Range("a11").select
Selection.End(xlDown).Select
X=Activecell.Row
Then use the other stuff to make bold.
Aloha
Jeff
D
Dave Peterson
Record a macro when you hide the details
Select the range you want bold
Edit|goto|special|visible cells onl
Format the selection to bold
And you'll have code that should work ok.
Select the range you want bold
Edit|goto|special|visible cells onl
Format the selection to bold
And you'll have code that should work ok.
H
Helmut
Hi Dude,
Subtotals...there are many and only one GRAND Total which is the LAST.
I need to BOLD the SUBTOTAL-LINEs of which there are many and NOT at the
bottom.
Subtotals...there are many and only one GRAND Total which is the LAST.
I need to BOLD the SUBTOTAL-LINEs of which there are many and NOT at the
bottom.
H
Helmut
Hi dave,
Can you translate this to Excel2007?
Can you translate this to Excel2007?
Dave Peterson said:Record a macro when you hide the details
Select the range you want bold
Edit|goto|special|visible cells onl
Format the selection to bold
And you'll have code that should work ok.
B
Bob Phillips
First you need to have the Developer tab showing.
Click the big orange Office button, then the Excel Options button. Select
Popular from the left pane, and then check 'Show Developer tab in the
Ribbon'.
You then have access to record as in pre-2007 Excel in the Code group.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click the big orange Office button, then the Excel Options button. Select
Popular from the left pane, and then check 'Show Developer tab in the
Ribbon'.
You then have access to record as in pre-2007 Excel in the Code group.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
D
Dave Peterson
There are shortcuts to do the equivalent of edit|goto (in xl2003):
You could hit the F5 key or hit ctrl-g.
You could hit the F5 key or hit ctrl-g.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.