+ Reply to Thread
Results 1 to 5 of 5

autofill horizontally headres for the whole used range

  1. #1
    Forum Contributor
    Join Date
    02-27-2020
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    447

    autofill horizontally headres for the whole used range

    Hi,

    I would like to autofill horizontally in order to create headers in the first row for all the columns in the used range.
    With my macro the autofill only stretches to the column in which in the first row a value is displayed. I would like to autofill horizontally for all the columns in the used range, so also for columns that have values in other rows than the second. So the headers should be "header 1", "header 2", etc.
    How can this be done?

    Please Login or Register  to view this content.
    Last edited by MaartenRo; 08-26-2022 at 06:53 AM.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,317

    Re: autofill horizontally headres for the whole used range

    Possibly...
    Please Login or Register  to view this content.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,978

    Re: autofill horizontally headres for the whole used range

    Untested, but maybe:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    02-27-2020
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    447

    Re: autofill horizontally headres for the whole used range

    @TMS Thank you, that works fine! Many thanks..

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,978

    Re: autofill horizontally headres for the whole used range

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Replies: 7
    Last Post: 11-21-2018, 04:59 PM
  2. Autofill Horizontally
    By trescuervo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2018, 10:51 PM
  3. [SOLVED] Autofill horizontally while maintaining formulas
    By pittsburghr2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2014, 01:27 AM
  4. Can you autofill horizontally and vertically?
    By keez1993 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2014, 03:59 AM
  5. [SOLVED] autofill vertical list horizontally with 2 blank cells in-between each list item
    By Phily915 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2014, 08:15 PM
  6. Autofill horizontally
    By JaDiMa in forum Excel General
    Replies: 23
    Last Post: 06-06-2010, 03:26 PM
  7. Autofill horizontally
    By skatmandu2002 in forum Excel General
    Replies: 4
    Last Post: 01-23-2009, 07:52 PM

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