+ Reply to Thread
Results 1 to 4 of 4

Adding columns to excel using macro

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    23

    Adding columns to excel using macro

    Hi,

    I would like to insert columns into my excel using a macro. The scenario would be like i have few columns of data. At a particular columns, which i try to name it "col", i want to insert an extra column into it. The ideal would be to be able to choose any column as "col" and insert a column there. However, I don't seem to be able to do it. I am not sure if its due to me not able to reference "col" properly or am i missing something? Thanks for the help i advance!

    Please Login or Register  to view this content.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,760

    Re: Adding columns to excel using macro

    Set is Missing

    Corrections:-
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    06-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Adding columns to excel using macro

    Thanks! Just want to ask a little further,if i want more than a column,say i want to insert 4 columns in one goal, is that possible?

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,760

    Re: Adding columns to excel using macro

    Try this...

    Please Login or Register  to view this content.
    Last edited by :) Sixthsense :); 06-11-2013 at 05:37 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1