+ Reply to Thread
Results 1 to 2 of 2

Insert columns in missing numbers horizontally in a range.

  1. #1
    Registered User
    Join Date
    11-22-2019
    Location
    Guatemala
    MS-Off Ver
    2016
    Posts
    3

    Insert columns in missing numbers horizontally in a range.

    I need your valuable help so that the following macro inserts columns in the missing numbers horizontally (in a row) of a selected range.

    What happens is that the following macro does not insert the columns when there are other adjacent ranges on the left or right side of the selected range.

    Please Login or Register  to view this content.


    What is wrong that doesn't insert the columns?

    Cross-posted at

    https://www.todoexpertos.com/pregunt...go-otro-codigo

    https://www.mrexcel.com/board/thread...range.1158156/
    Last edited by 6StringJazzer; 01-11-2021 at 09:06 PM. Reason: Added code tags, post links; corruption in database required special handling

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Insert columns in missing numbers horizontally in a range.

    If I understood you correctly, try selecting the cells and running this:
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

+ 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. [SOLVED] Compare two columns on separate sheet, if missing, insert missing data
    By lilvictorians in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-03-2019, 11:44 PM
  2. Identification of duplicate numbers and missing numbers in multiple columns
    By kswapnadevi in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-18-2018, 11:50 AM
  3. Replies: 4
    Last Post: 10-19-2017, 08:12 AM
  4. [SOLVED] Sum the numbers horizontally across columns based on header names
    By BryGuy81 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2016, 02:01 AM
  5. insert missing dates in columns vba
    By matija385 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2016, 11:15 AM
  6. [SOLVED] insert missing date columns
    By Hang Glider in forum Excel General
    Replies: 4
    Last Post: 10-21-2014, 03:32 PM
  7. insert missing columns
    By chi11 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2012, 06:32 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