merged cells

Hi all, I'm trying to fill rows with colours dependent on pass or fail. The issue is some of the cells are merged including the one that has the pass or fail selection, and hence only fills the top row of that merged cell. Please see image 1 attached for a better idea, this is how it currently...

Hi all, Is it possible to Copy a cell value and paste that same cell value when the original cell is merged without the excess empty cells? The merged cell is 4 cells horizontally so when the macro runs, it copy and pastes the value of 1 cell value and 3 empty cells Thanks

Hi All, I need to count the number of occurrences of merged cells within an active worksheet. Eg if 1 merged cell exists over what was previously 4 cells, then I just want to count the 1 occurrence. I presume this is possible with VB ? Thanks

Hello! I have a larger data set that has merged cells in column A (see example below). Pretend that in column A ("Animal") that lines 2 and 3 are merged, and that lines 4,5,6 are merged. Nothing in column B is merged. the interface isn't allowing me to merge anything here. column A...

Hello all, thank you for taking a look at this. I am using Excel for Mac 2011, OS X Yosemite. I am setting up a sales tracking database for my bakery. The data is entered daily, and I am building weekly and monthly summary sheets. Each product (e.g. Chocolate Chip Cookie) is a row. Each column...

Hi everyone, I was struggling a long time with the autofit row height by merged cells, and finally i have a macro that works. My only problem, the row height becomes far too big. How can i make the row height a good fit? This is my code: Option Explicit Public Sub AutoFitAll() Call...

Hi All, :) I have been handed some work but am having some trouble with it, I need to do some data validation on a cell (A FRIGGIN MERGED CELL!) the user needs to complete a form (not a userform, created on a sheet with many merged cells) the problem I'm having is I need to check the value of...

I'm putting together some code that will allow me to automate data cleaning. One of the tasks I desire to do is to capture the location of any merged cell and write it to a sheet (for tracking purposes) before I unmerge the cells. The code I have works ok, but it writes a value for each merged...

First off, I know, merged cells are the Devil and should be avoided at all costs. :diablo: That said, I have no choice but to deal with them in this spreadsheet. I get a daily Excel product, which is generated from a third party system. I then have to make multiple formatting (color code, hide...

Hi all, I have a macro giving me headaches.. Its goal is: 1. To copy 8 columns from 'Global List' to 'Front'. Global List sheet has some merged cells and Front sheet can't have them so as to be aligned with the rest of the info already there when I copy these columns. I use this code: Sub...

Let me start by sating I'm fairly versed in Excel, and have been trying to figure this out and searching for an answer for almost a week,:confused: so any help at all would be GREATLY appreciated! I found these two codes (the top two) in the forums, but can't seem to get it to work while saving...

Hi, I have experienced a problem with a calculation using a value in a merged cell. The calculation was this =((H481*1000)*(100/(100-E481))) and E481 was three cells merged together. At some point during the use of the spread-sheet the value in E431 got divided by 3. It is no longer...

I have a three cell merged conditional formatted section with the conditional formatted that has the color starting from one end and fading to white. The information in the cell is derived from a drop down menu. When the information changes only two of the cells changes and the last cell stays...

Hi, I may be asking the impossible or this may have been asked already if so apologies in advance. I am trying to create a macro that will search for all unique values within a sheet and list them on another sheet, by identifying the values based on the adjacent merged field. Additional I am...

Having a problem with the VBA error "Cannot change part of a merged cell" Here is my code. It clears the range on the first sheet, then hides the Raw Samples sheet. The loop then clears the ranges on the unhidden sheets in the workbook because they are formatted the exact same. This code only...

Hello everyone, I am working on this part of a big code and I am having issues with using .find with mergeArea as I cannot pull out the information and add it into a new sheet. Actually this part of the code can read the value in merged cells (I did an inspection) but it does not pull them out...

Hi, I have an unlocked merged cell that I want to automatically Autofit when multiple lines of text are added. The code below does that but for some reason changes the protection so that all but the 1st cell are locked resulting in the merged cell being locked. When I protect the workbook and...

Hello all. Here is my data (there are four columns and ~5000 rows): ________________________________________________ Name.........Start Time.........End Time..........Duration ________________________________________________ ..................8AM..................9AM..................1 hour...

Hi all I've looked online for VBA code to insert a row with specific contents (ex. 'Example1' after every merged data cell (it should check for data) in a specified range (B13:B269), but none seem to work properly with the merged cells. Column B has merged cells, but column D does not (Column C...

Hopefully someone can help me with a problem I'm having with merged cells and a macro not getting on too well... On a sheet titled "Data", column A has a list of reference numbers. These are taken from column C on sheet one. Using "if(Sheet1!C5 = "","",Sheet1!C5), Cell A5 is populated...