+ Reply to Thread
Results 1 to 4 of 4

A macro for inserting rows while copying format and formulas depending on the button pos

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    A macro for inserting rows while copying format and formulas depending on the button pos

    Hello everyone,

    As the title says, I would kindly ask of you if you can suggest a code for VBA excel with the purpose of automatically copy and pasting a group of Rows just above or next to the button while keeping formats and formulas without values(data inside cells).
    If it is not much to ask I would also like a code that can delete rows next to the button.

  2. #2
    Registered User
    Join Date
    04-09-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: A macro for inserting rows while copying format and formulas depending on the button p

    Sorry for not providing a sample. Here you go. To review my request, I would like a macro to copy paste a group of rows next to the macro assigned button without copying values as well.
    I will assign macro buttons that will need to copy and paste a group of rows for example A41:A47. This is the range of cells that each row starts with.

    Regards,
    PM
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-09-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: A macro for inserting rows while copying format and formulas depending on the button p

    A small Bump :D!

  4. #4
    Registered User
    Join Date
    04-09-2013
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: A macro for inserting rows while copying format and formulas depending on the button p

    Can no one help me with this pls?

+ 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