+ Reply to Thread
Results 1 to 4 of 4

macro to insert header after last used column

  1. #1
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Question macro to insert header after last used column

    Hi GURUS,

    I need a macro that inserts a header name after the last used column.


    for example, if i have A to E columns in xl, the macro should enter the header name in F column (in F1).

    i have 1000 of records like this and the columns too vary... pls help me on this.....

  2. #2
    Registered User
    Join Date
    09-27-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    86

    Re: macro to insert header after last used column

    Hi,

    Use the below code to find the column next to the last used column and update your values.

    Please Login or Register  to view this content.
    regards,
    lokicl

  3. #3
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: macro to insert header after last used column

    may i know what "xfd1" means???

  4. #4
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: macro to insert header after last used column

    any how , the code works good. Thanks so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro for extracting data from a long column and insert it in its own column with a header
    By ChemistryStudent in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2014, 04:41 AM
  2. [SOLVED] How to insert header row with every change in value in a column
    By sayedzada in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2014, 06:15 AM
  3. [SOLVED] VBA Insert Column And Add Header On Multiple Sheets
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2014, 10:50 AM
  4. [SOLVED] VBA macro to add header text, insert & copy-down formula, move column
    By shootstill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2014, 05:44 AM
  5. Replies: 1
    Last Post: 05-02-2008, 04:57 AM

Tags for this Thread

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