merged cells

  1. M

    Insert merged row into Excel, with duplication of the row(s) formatting above, using Command Button

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

    VBA wont work due to merged cells

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

    VBA Excel365 - Need to find the last merged cell in a column

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

    excel 2016 wrap text problem

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

    Using Go to Special to select all balnk cells including merged cells

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

    Select the range of cells which contain Merged cell in between

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

    Copy & Paste Values in Single Cells to Merged Cells via VBA

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

    Autofit Row Height of Visible Cells Only (including merged cells)

    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)...
  9. A

    Autofit Row Height of Cells (including merged cells) for Visible Rows Only

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

    vba to help with merged cells

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

    INDEX/MATCH error "#N/A" when I have some merged rows, to use RANK as an end goal

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

    Unable to Tab from unlocked merged cells to any other unlocked cell

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

    VBA Amend Column Width (Problem is Merged Cells)

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

    Conditional Formatting MOD(ROW(),2)=0 on MERGED CELLS

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

    AutoFit Row height for Merged cells with data exceeding row height limit

    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...
  16. 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...
  17. B

    Clear Contents of Merged Cells

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

    Filtering on Merged Cells

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

    Populate & maintain client worksheets from a host worksheet

    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 &...
  20. D

    Merged cells using drop-down list not filling correctly

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

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