subtotal bold
 

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

subtotal 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?

subtotal 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?

subtotal 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?

subtotal 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?

subtotal 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

subtotal 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?

subtotal bold
 

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

subtotal bold
 

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

subtotal bold
 

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