Results 1 to 6 of 6

Insert rows for multiple selected rows

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2018
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    3

    Insert rows for multiple selected rows

    Hello all,

    Can someone modify this code? It does not insert the specified rows in the input box for each selected row, just for one.

    Sub test()
      Dim rowcount As Integer
      zeilenanzahl = InputBox("how many rows?")
      Range(ActiveCell, ActiveCell.Offset((rowcount - 1), 0)).EntireRow.Insert
      Cancel = True
    End Sub
    Best,
    JN
    Last edited by jeffreybrown; 05-25-2018 at 05:06 PM. Reason: Please use code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert a value into a certain column of selected rows
    By machinerydlr in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-25-2017, 08:18 PM
  2. Insert multiple rows each specific number of rows
    By salmasaied in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-24-2016, 09:58 AM
  3. [SOLVED] Insert multiple rows each specific number of rows
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 05-21-2016, 10:36 AM
  4. Return indexes of rows when multiple rows of a table are selected.
    By samkumar in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2013, 04:54 AM
  5. Code to insert rows between selected cells
    By DeepakS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2013, 08:18 AM
  6. Replies: 0
    Last Post: 03-06-2013, 05:44 PM
  7. [SOLVED] Insert Multiple Rows Based Off Number in Cell and Copy Data From Above New Rows
    By tstell1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2012, 04:15 PM

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