merged cell

  1. B

    VBA-Copy & Paste Merged Cell into Merged Cell

    I'm trying to copy and paste cells from sourceSheet to destSheet. The macro works fine if it's not a merged cell, however, when it comes to merged cells it doesn't paste in the values. Can someone help me with the merged cell block below? It's fine to assume if the sourceCell is a merged cell...
  2. C

    Copy and paste data from 10+ workbooks into one "Master" sheet

    Hi all, I need to copy data from workbooks all contained in a folder called "Cycle Data" into a master sheet. From each of these sheets I need cells H66 and Q66 to be copied and pasted into a table that contains merged cells. I also need the name of the worksheet to be carried over with the...
  3. tycasey17

    Filtering Merged Cells

    I have a dashboard but with organization personnel below it. I have merged B2:C2 and in B3:C3 I have the filter arrows turned on however when I attempt to sort by A-Z it gives me an error. Is there a way to fix this?
  4. B

    Autofill Numbers In Merged Cells

    I know there are some topics about autofill in merged cells, but I couldn't find what I need. I don't even know if it's possible. Is there a way to autofill numbers in this kind of table? (see image bellow). There are cells merged in rows and columns. Numbers with 2 or 3 digits, depending on...
  5. C

    How to centre image in merged cells

    Hello all. I require a little guidance on how to centre an image within 2 merged cells the code I have been using to centre an image in one cell does not work for 2 cells. No matter how I try I just cant get it to work. Is there a way to alter the code to allow for this. See bellow for the code...
  6. A

    Rookie needing help with Macros and formula assistance

    Hello I am pretty much a VBA rookie, but learning a lot in the last month so please talk to me like I am six and explain as much as possible :) I had a thought about putting in a couple macros depending on if a cell is blank or has an "X" I want to have a macro ran depending on which option is...
  7. L

    Counting merged Cells based on criteria

    Hi, I have read a lot of forums discussing merged cells and how to calculate the number of merged cells based on the criteria given, however the formula below only returns the number of merged cells for the first set of merged cells and not for the entire column. If I wanted to count the number...
  8. J

    Target.Address is a merged cell

    Hi, I am struggling with the VBA code below. The code works fine until I delete the contents of the target cell, this does not have the desired effect of hiding the row below. I believe this is due to the target cell B315 being merged with B316. Any ideas how I can rectify this? Thanks, Justin...
  9. B

    Fill Down With Merged Cells

    I have Column AH which has every two rows merged (AH10:AH111,AH12:AH13) etc. In column AQ I have an equation that I want to be able to fill down that references column AH. My issue is that the first cell in Column AQ references the merged cell, but the second references only half the merged...
  10. O

    Copy/paste Row 1 after every merged cell

    Hey Guys! Im looking for a VBA code that will copy row 1 from column A to M , and will paste row 1, a line below every time it finds a merged cell. And I want this to loop until the last Merged cell. Please refer to my code below and see if it makes any sense to you. Can someone please help...
  11. A

    Failing Automatic Row Height for Merged Cells with Text Wrap

    Excel Friends, Th procedure Automatic Row Height for Merged Cells below works for me, but partially. It changes to the Row Height but not all the times. No evident reason. Most of the times I modify the length of the text, hit Enter and nothing happens. So, after hitting Enter I go back up to...
  12. S

    VBA Autofit merged cell

    Hi, I am relatively new to VBA and I have found a Macro which autofits merged cells to ensure they are all visible (by adjusting the row height). the only issue is, the VBA I have leaves a huge gap above the text that is autofitted. I can't seem to identify the issue. Any assistance, or any...
  13. I

    Spell check either Active X text box, text box or merged cells in excel 2016

    I hope someone can help me. I have a protected workbook with protected work sheets (2016). I built the spreadsheet with merged cells for user comments, but have now been asked to allow spell check in the comments field. In the example below I would need a text box/merged cell from b2:e3 (with...
  14. C

    Large Dependent Data Validation, 1 Range, Multiple Values

    Hello All, I have UTFSE however i really am having difficulty explaining this issue so please bear with me. I have a list of products and its used for Data Validation, the idea is i can just select the product name, the next step is to be offered a list that will only show me the relevant...
  15. O

    Extracting multiple entries in a single merged cell to individual row

    Hell everyone! This is my first time posting on this forum, but I have a fairly basic question. I have received a data dump with multiple values in a single merged cell that I need to extract into individual rows so I can preform a vlookup on this data. It looks like this expect on a much...
  16. J

    Name of Merged Cells

    I am stumped! I have a good level of VB experience and have combed through VBA posts for answers but this one is beating me. Here is where I am at: - Merged 4 cells together (A1:B2) - Renamed merged cells "SampleBlock" - Select the range "SampleBlock" with the cursor so that it is the active...
  17. D

    Printing issue - text cut off in the middle of a merged cell

    Hello I have an excel workbook as a dashboard. One area is for comments and is a combined set of cells (merged/ text wrapped etc) Visually all looks fine as it does in print preview. Even converted to PDF it looks fine. the Problem is prining. When you print certain lines cut the text off...
  18. M

    Cannot change a part of a merged cell (cell is not merged, I am not copying or pasting)

    I have a spreadsheet that an admin goes into on a daily basis and manually enters data in every cell down a column. About every other cell she gets the error, "Cannot change part of a merged cell." I am confused because the cells in the column are not merged. She is not copying or pasting...
  19. T

    VBA to resize merged cells textboxes

    Please help me with this, I've been looking for a good solution to this for ages! I'm trying to create a macro which runs and resizes merged cell text boxes to fit the text within them. I found this code online on a different forum, which was working (albeit very slowly) a few days ago...
  20. L

    Check if merged cells are blank

    I have an Excel 2003 spreadsheet containing a mix of UK date and currency formatted cells. I cannot change the structure of the spreadsheet. In VBA, during a worksheet change event, I want to check if the user has deleted the data from a number of ranges comprised of merged cells. If the user...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back