Copy a merged cell
Results 1 to 3 of 3

Thread: Copy a merged cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2018
    Location
    NSW, Australia
    Posts
    868
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Copy a merged cell

    What is the vba to copy a merged cell, G7:H7?

  2. #2
    Board Regular
    Join Date
    Jul 2014
    Location
    Anywhere
    Posts
    450
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy a merged cell

    range("G7").copy
    refer to the first cell of the merged range for values
    But if you want to copy and paste the entire range keeping the merged cells, then range("G7:H7").copy
    Last edited by eduzs; Aug 22nd, 2019 at 07:52 PM.
    Using Excel/Word 2010.
    Backup your original file before doing any modification.

  3. #3
    Board Regular
    Join Date
    Sep 2004
    Posts
    1,356
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy a merged cell

    Code:
    Range("G7").MergeArea.Copy
    There are people who work a lot and make many mistakes. There are people who work a little and make few mistakes. I know people who don't make any mistakes.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •