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...

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...

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?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...