Re: Insert Column to the left in a list

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Jun 19, 9:29 am, Shane <shanewith...@xxxxxxxxx> wrote:
I am using lists to help with my data, and I want to be able to add a
new column when the month starts. So I want to add a column in the
list to the left of my total column. When I record my steps with the
Macro recorder it gives me this.

Selection.ListObject.ListColumns.Add (28) which always puts a new
column at the 28 position.

the other code of

ActiveCell.Offset(0, 1).EntireColumn.Insert

doesn't work with lists. I have named the range of the total row to
Total12 (because I am summing the most recent 12 months). Thanks for
your help.

Shane

Nevermind. I figured it out.

Thanks anyway
.

Relevant Pages

  • Insert Column to the left in a list
    ... list to the left of my total column. ... Macro recorder it gives me this. ... doesn't work with lists. ... Total12 (because I am summing the most recent 12 months). ...
    (microsoft.public.excel.programming)
  • How to - join two columns from separate lists
    ... I am looking to join two columns in two separate WSS lists into a third ... summary list with a calculated field. ... The total column would be the sum of the current and forecast columns for ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: reduce()--what is it good for? (was: Re: reduce() anomaly?)
    ... Any reduction that doesn't involve summing won't be handled by sum. ... Flattening a list of lists is a good example. ... removing an existing, builtin function seems ...
    (comp.lang.python)
  • Re: sum(if and wild cards
    ... that would count the number of occurances instead of summing? ... Secondly, if you are using lists for your Data Validation, then add ... find the selection matches in 3 columns and then add numbers from the ...
    (microsoft.public.excel)
  • Re: sum(if and wild cards
    ... that would count the number of occurances instead of summing? ... > I have a user input from 3 selections using data validation lists. ... > more of the vaildation lists if he/she wants everything for that> selection ...
    (microsoft.public.excel)