Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotalling where # of columns vary
I am trying to setup a template file and need to
programmatically insert subtotals, but different users may have more columns than others. The first 3 columns will be the same for all users and the data will always be a list with column names. Any help would be appreciated. MC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotalling where # of columns vary
set rng = range("A1").CurrentRegion
msgbox "number of columns: " & rng.columns.count Not sure what you need beyond that. Regards, Tom Ogilvy MC wrote in message ... I am trying to setup a template file and need to programmatically insert subtotals, but different users may have more columns than others. The first 3 columns will be the same for all users and the data will always be a list with column names. Any help would be appreciated. MC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotalling | Excel Worksheet Functions | |||
Subtotalling | New Users to Excel | |||
Sum of columns that vary in position | Excel Worksheet Functions | |||
Subtotalling | Excel Worksheet Functions | |||
How can i vary the width of columns in a histogram? | Excel Worksheet Functions |