Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting rows using SubTotal
I want to color the sub-total row and insert a row after the subtotal row.
What vba code locates a sub-total row since the row names change every time the report is run? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting rows using SubTotal
If the subtotal row is always the last row, you can capture the last row
with this: LastRow=cells(rows.count,1),end(xlup).rows (assuming that there is data in column 1) cells(Lastrow,1).value = new stuff in column A cells(Lastrow,2).value = more new stuff in column B Glen ps use the Conditional Formatting feature to automaticlly color the SubTotal row "SharonInGa" wrote in message ... I want to color the sub-total row and insert a row after the subtotal row. What vba code locates a sub-total row since the row names change every time the report is run? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting rows using SubTotal
I run sub-total from the Command bar setting the sub-total to break on the
type of account: cash, equity, .... The number of accounts change each month so a subtotal for one month may be listed on row 10 and for another month may be listed on row 30. "Glen Mettler" wrote: If the subtotal row is always the last row, you can capture the last row with this: LastRow=cells(rows.count,1),end(xlup).rows (assuming that there is data in column 1) cells(Lastrow,1).value = new stuff in column A cells(Lastrow,2).value = more new stuff in column B Glen ps use the Conditional Formatting feature to automaticlly color the SubTotal row "SharonInGa" wrote in message ... I want to color the sub-total row and insert a row after the subtotal row. What vba code locates a sub-total row since the row names change every time the report is run? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal formatting | Excel Discussion (Misc queries) | |||
subtotal formatting | Excel Worksheet Functions | |||
Auto subtotal every 100 rows | Excel Discussion (Misc queries) | |||
formatting subtotal lines | Excel Discussion (Misc queries) | |||
using SUBTOTAL() on rows that have been hidden | Excel Worksheet Functions |