maheshmurthi
New Member
Hi,
I have a table with around 12 columns - of this only 6 are visible - have hidden rest of the columns by formatting with dark shades.
This table is a template and gets copied when a new sheet is created.
When the table gets copied to a new sheet and a new row is added through table.listrows.add - the totals rows loses its formatting.
I want to select specific columns (the first 6 ) and then format it with background colour and font colour. How do I do this ?
Following is the line:
Range(returns_tbl.Name & "[[#Totals],[Date]:[Remarks]]").Select
I have a table with around 12 columns - of this only 6 are visible - have hidden rest of the columns by formatting with dark shades.
This table is a template and gets copied when a new sheet is created.
When the table gets copied to a new sheet and a new row is added through table.listrows.add - the totals rows loses its formatting.
I want to select specific columns (the first 6 ) and then format it with background colour and font colour. How do I do this ?
Following is the line:
Range(returns_tbl.Name & "[[#Totals],[Date]:[Remarks]]").Select