Closed Thread
Results 1 to 3 of 3

How to insert multiple rows with inputbox on multiple sheets?

  1. #1
    Registered User
    Join Date
    06-18-2018
    Location
    Denmark
    MS-Off Ver
    Office 365
    Posts
    22

    How to insert multiple rows with inputbox on multiple sheets?

    Hi all,

    i have tried to insert multiple rows on 2 sheets at the same time with inputbox, but can't get it to work. I have tried to array the 2 sheets before the code, but it only inserts the rows on the active sheet.

    I can get it to work on 1 sheet. My code look like this when i insert multiple rows on 1 sheet:

    Please Login or Register  to view this content.
    This code works whits 1 row, but i need to insert multiple rows.

    Please Login or Register  to view this content.


    How do i modify the code so it inserts multiple rows the same place in 2 sheets, and copy the formula down.

    The sheets af called "Tilbudsliste" and "Aconto, kontraktarb."

    The reason for the code is that i have locked the cells that contains formula.

    I hope it makes sence.
    Last edited by smasma; 06-22-2018 at 08:04 AM.

  2. #2
    Registered User
    Join Date
    06-18-2018
    Location
    Denmark
    MS-Off Ver
    Office 365
    Posts
    22

    Re: How to insert multiple rows with inputbox on multiple sheets?

    This is posted in the wrong forum i see.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,804

    Re: How to insert multiple rows with inputbox on multiple sheets?

    Duplicate post, thread closed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do you insert rows into multiple sheets in a workbook?
    By Marketing Queen in forum Excel General
    Replies: 3
    Last Post: 11-17-2015, 11:25 AM
  2. VBA Help - Insert Rows on Multiple Sheets
    By luvmyfam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2014, 04:08 PM
  3. Macro to insert/delete rows in multiple sheets
    By lorigies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2014, 11:15 AM
  4. Macro to insert rows in multiple sheets and copy formulas
    By syt0x in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-25-2013, 11:06 AM
  5. Replies: 0
    Last Post: 11-08-2012, 01:07 PM
  6. Using inputbox to insert multiple numbers into formula
    By JMT-Z in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2008, 04:02 PM
  7. [SOLVED] insert Rows with Formulas in Place on Multiple Sheets?
    By Michael Link in forum Excel General
    Replies: 5
    Last Post: 03-09-2006, 10:00 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