Results 1 to 4 of 4

Thread: Macro to Add Columns in Excel

  1. #1
    Join Date
    Aug 2009
    Posts
    25

    Macro to Add Columns in Excel

    I have a Excel spreadsheet to track employee information. I need to add macro in that adds three columns at the end of the first sheet and it must populate the three new columns with formulas on all records in the sheet? Any recommendations and suggestions are appreciated.

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    Re: Macro to Add Columns in Excel

    Use this code :
    Code:
    Sub CalDat()
    Dim wC As Worksheet
    Dim wT As Worksheet
    Dim rU As Range
    Dim lRw As Long
    
    Set wC = Sheets("Code")
    Set wT = Sheets("T_Write_off")
    Set rU = wsTWO.UsedRange
    lRowEnd = rUsed.Rows.Count + rUsed.Row - 1
    wT.Range("AH1:AJ1").Formula = wC.Range("AH1:AJ1").Formula
    wT.Range("AH2:AJ" & lRowEnd).Formula = wC.Range("AH2:AJ2").Formula
    wT.Activate
    Range("A1").Select
    Selection.End(xlToRight).Select
    End Sub

  3. #3
    Join Date
    Dec 2008
    Posts
    371

    Re: Macro to Add Columns in Excel

    Check this for example :
    Code:
    Sub addcol()
    
    LasCol = Cells(1, Colu.Count).End(xlToLeft).Column
    
    Colunt = LastCol
    Do While Colunt > 1
    If Cells(1, Colunt) > Cells(1, ColCount - 1) + 1 Then
    Columns(Colunt).Insert
    Cells(1, Colunt) = Cells(1, ColCount + 1) - 1
    Else
    Colunt = Colunt - 1
    End If
    Loop

  4. #4
    Join Date
    May 2008
    Posts
    4,348

    Re: Macro to Add Columns in Excel

    You need another macro to rearrange the position of columns. For eg. in excel there are A, B, C, D ,E1 COLUMNS. (three in your case). Split your screen, use the F8* key and see what you procedure does work in Excel.

Similar Threads

  1. Excel 2003 Macro doesn't work in Excel 2007
    By jjaw in forum Windows Software
    Replies: 3
    Last Post: 03-01-2014, 02:28 PM
  2. How to divide two different columns data in Excel
    By Chini mao in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 05:47 PM
  3. How to sort spreadsheet or columns in Excel
    By Kungfu Pandey in forum Windows Software
    Replies: 1
    Last Post: 08-01-2012, 01:13 PM
  4. How to multiply two columns in Excel
    By Lanka Boy in forum Windows Software
    Replies: 2
    Last Post: 08-01-2012, 02:06 AM
  5. How to expand and collapse columns in Excel
    By Asaph in forum Windows Software
    Replies: 5
    Last Post: 31-08-2010, 11:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •