+ Reply to Thread
Results 1 to 2 of 2

Clear contents merged cells

  1. #1
    Registered User
    Join Date
    04-06-2021
    Location
    spain
    MS-Off Ver
    professional plus 2010
    Posts
    34

    Clear contents merged cells

    Greetings,

    I've just been working on a macro that clears our template after we use it.
    I imagined something like this would get the job done

    Please Login or Register  to view this content.
    But it says that it cannot change merged cells, is there a way around it?

    Ok, silly me. This fixes it.
    Please Login or Register  to view this content.
    Last edited by Vlad2112; 06-14-2021 at 12:55 PM.

  2. #2
    Forum Contributor
    Join Date
    02-09-2021
    Location
    New York
    MS-Off Ver
    Office 2019
    Posts
    145

    Re: Clear contents merged cells

    Hi Vlad2112,

    You can do it this way:

    Please Login or Register  to view this content.
    Hope this helps.

+ 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. Clear contents in Merged and Un-Merged, Unprotected Cells of a Protected Worksheet.
    By Magnetite in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2020, 04:23 AM
  2. [SOLVED] Clear merged and non-merged cells in named range.
    By IMM Tech in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2018, 12:37 PM
  3. Clear merged cell contents in comand button(clear all)
    By mohan_984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-25-2015, 10:39 AM
  4. [SOLVED] Clearing Contents Below Merged Cells
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-30-2014, 07:14 AM
  5. Split merged cells and distribute contents
    By eugene w in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-03-2009, 08:09 PM
  6. Clear contents of all unlocked cells (many are merged cells)
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-08-2009, 09:21 AM
  7. Clear Contents won't work on merged cells
    By ArthurJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2006, 01:25 PM

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