How can I have the entire ROW in the subtotal routine BOLD?

Hi

Rows(X).entirerow.font.bold=true

where X is the row number.

Regards,

Per

"Helmut" skrev i en meddelelse
...
How can I have the entire ROW in the subtotal routine BOLD?

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)



"Per Jessen" wrote in message
...
Hi

Rows(X).entirerow.font.bold=true

where X is the row number.

Regards,

Per

"Helmut" skrev i en meddelelse
...
How can I have the entire ROW in the subtotal routine BOLD?

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.

"Bob Phillips" wrote:

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)



"Per Jessen" wrote in message
...
Hi

Rows(X).entirerow.font.bold=true

where X is the row number.

Regards,

Per

"Helmut" skrev i en meddelelse
...
How can I have the entire ROW in the subtotal routine BOLD?

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

"Helmut" wrote in message
...
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.

"Bob Phillips" wrote:

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)



"Per Jessen" wrote in message
...
Hi

Rows(X).entirerow.font.bold=true

where X is the row number.

Regards,

Per

"Helmut" skrev i en meddelelse
...
How can I have the entire ROW in the subtotal routine BOLD?

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.


"Dude Ranch" wrote:

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

"Helmut" wrote in message
...
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.

"Bob Phillips" wrote:

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)



"Per Jessen" wrote in message
...
Hi

Rows(X).entirerow.font.bold=true

where X is the row number.

Regards,

Per

"Helmut" skrev i en meddelelse
...
How can I have the entire ROW in the subtotal routine BOLD?

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.

Helmut wrote:

How can I have the entire ROW in the subtotal routine BOLD?

--

Dave Peterson

Hi dave,
Can you translate this to Excel2007?

"Dave Peterson" wrote:

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.

Helmut wrote:

How can I have the entire ROW in the subtotal routine BOLD?

--

Dave Peterson

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)



"Helmut" wrote in message
...
Hi dave,
Can you translate this to Excel2007?

"Dave Peterson" wrote:

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.

Helmut wrote:

How can I have the entire ROW in the subtotal routine BOLD?

--

Dave Peterson

There are shortcuts to do the equivalent of edit|goto (in xl2003):

You could hit the F5 key or hit ctrl-g.



Helmut wrote:

Hi dave,
Can you translate this to Excel2007?

"Dave Peterson" wrote:

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.

Helmut wrote:

How can I have the entire ROW in the subtotal routine BOLD?

--

Dave Peterson


--

Dave Peterson