merged cells

Hello there! I'm an enthusiastic if incredibly amateur Excel user- I usually just use google to figure things out but I'm hitting walls with this issue, so thank you in advance for any support or help you can offer! I'm trying to build a feature into an Excel sheet, so that if you click on a...

Hello everyone, I am working on a list where the Area from A1 to Q7 is basically the header (Client Name, Location, Project Start, Project End, etc...), which consists mostly of merged cells. In this list are items listed that a client gets. So the listing of the Items starts from A8, and...

in a sheet I have column A with merged rows in groups of 7 rows Using VBA I want to find either: - if the ID is already present a row: return the row number where the value is found - if the ID doesn't exist: return the row number of the first free cell I was using this code in another sheet...

Hi All! Searching all over the internet it seems the problem can't be solved, as it is just like that. But may be someone still can find a solution. In workbook, several sheets ( a lot of sheets) have free text with merged cells ( columns) and not all the text is visible. ( attached). Autofit...

Does anyone know of an easy way to select all empty cells in a worksheet using VBA. I wanted to take a protected sheet and use VBA to unprotect it. Then unlock all the cells on the sheet that are empty and then re-protect the sheet. I was using the Go To Special feature but found out it will...

Hai Dudes, I would like to select the range of cells in one row which contains some merged cells in between. The macro has to be run for many files with different range of cells. For example File1 has to be select from C5:C10, file2 has to select from C5:C20. There are some cells merged in the...

<tbody> A B C D E F G H I J 1 Kit P/N Kit S/N Kit Part Kit Parts S/N Kit P/N Kit S/N 2 Kit 1 123 Part 1 001 Kit 1 123 3 Part 2 002 Kit 2 456 4 Part 3 003 Kit 3 789 5 Kit 2 456 Part 1 004 6 Part 2 005 7...

I am trying to autofit the height of cells (including merged cells) for visible rows only when I have filtered a set of data. Below I've listed cell references: The range of cells A2:A19 are all merged together as one (and there are about 5 lines of text within that group of merged cells)...

Hello, I have a file that contains multiple groupings of merged cells, as well as many cells are not merged. I need to be able to filter a column and have all of the visible rows auto-fit the height so I can view all the text within (some will be merged and others will not be). I have found...

Hey guys, I am trying to create a macro which deals with merged cells. The data I deal with comes from a table in powerpoint. when i copy the data over a lot of the cells end up being merged (I'm not sure why, but it's not merged in the ppt). what I want to do is to unmerge all the cells, then...

Hello, I have gotten the INDEX/MATCH formula to work just fine when it is all neat and orderly. But I am trying to neatly RANK my investment clients, but because my manually-entered values in the spreadsheet above where I want to view my RANK Table, I have several column/rows that are merged...

Hello. I apologize if this question has been asked. I tried to locate any threads pertaining to my issue but could not locate what I was looking for specifically, but I could have overlooked any that were posted. I have a locked worksheet with several unlocked cells. Some of the cells are...

Hi All, I need to automatically amend a column width, which is easy with VB. Script supplied below. However, the author of the spreadsheet decided in their wisdom (d'oh!) to incorporate merged cells. Unfortunately, I need to retain these numerous and illogically placed merged cells. is there...

Dear Experts, beginners question here; MOD(ROW(),2) does not work on Merged Cells (?) in my table, cells A1:A2 , A3:A4, A5:A6, etc are merged and thus the mod row function in conditional formatting does not work. how to overcome this ? Thanks in advance Desmond

I've been racking my brain for a long time on this and I'm absolutely stuck. I have a unique excel file with some issues that I just can't figure out. I have a worksheet, "Form", with drop down user selections, that copies the selection into a second worksheet, "Final" (Final!A22:A25=Form!B3...

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

Thanks all for looking. I have done some research and came up with the code below for clearing merged cells. The problem i have now is I need to add some more ranges of merged cells to the code and am unsure how. I need to add for the line with w5:x39 to carry on with more ranges.Example...

Good Morning, A co-worker is trying to use a filter on a column that has 15 rows with a merged cell. However, when she uses the filter, it naturally only recognizes the cell where the text is writte and does not display th other 14 rows. I built a work-around for her but I'm now curious if...

Does anyone have a suggestion how to go about populating and maintaining client ws's from a host, or master ws of data? The table below is what the master worksheet will look like and contain. I need to figure out how to auto-populate / maintain: In a CS1 ws the details about Project 1 &...

I've merged cells D10 to E12 and want it to show a temperature from a drop-down list, conditionally formatted to fill red, amber or green accordingly. The issue is that only the top row (D10 and D11) of the merged cells change colour whereas I want all six merged cells to reflect the change...