+ Reply to Thread
Results 1 to 3 of 3

macro inserting and copying rows

  1. #1
    Registered User
    Join Date
    05-11-2004
    Posts
    2

    macro inserting and copying rows

    Hi there, I use the attached macro for inserting and copying multiple rows
    E.g as the active cell is 5 so the macro replaces this row by 5 rows with the same data.
    Now I need a small change in this macro
    All the cells of the column of the active cell should always be copied as 1 instead of the original 5(in this example)
    As I am a newbie in vba any help really appreciated
    Thanks beforehand
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    Try to add the row marked in blue:
    Please Login or Register  to view this content.
    Regards,
    Antono

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Or maybe like this, without a loop:
    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)

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