+ Reply to Thread
Results 1 to 2 of 2

macro to copy range hidden paste in a specific location

  1. #1
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    macro to copy range hidden paste in a specific location

    Hello,

    I have recorded the below macro and I am not very happy with it. Can you please help me to enhance the macro and add the following:

    I need to copy the range "ROW" and past it below the range "MENU". Also the range "ROW" (ROW = copy of 3 line with some cells merged) is hidden.

    I need to unhide and hide back the rang ROW. Right know I have to leave the range appearing otherwise my macro doesn't work.

    HTML Code: 
    Thanks,

  2. #2
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Re: macro to copy range hidden paste in a specific location

    in fact I would to insert the copy range under the range "MENU" and remove the ("A7:A9").

    HTML Code: 

+ 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. Reference a date, then copy and transpose paste into a date specific location
    By nelmsd in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-26-2013, 03:30 PM
  2. Copy and paste specific range to date specific range in alternate sheet
    By alanalmarza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 08:29 AM
  3. [SOLVED] Need Macro to select and copy data, paste it to a new location, then delete the old row
    By summerela in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 09-25-2012, 05:22 PM
  4. [SOLVED] Macro to copy a specific range from a hidden sheet
    By dumblonde in forum Excel General
    Replies: 7
    Last Post: 05-10-2012, 02:50 AM
  5. Copy specific range to offset location
    By Mister P in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2009, 07:29 AM

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