merge cell

  1. G

    Insert various photos at one in merge cells

    Hi, Please help me, when i try to insert many photos (50) in a column of normal cells the 50 photos get inserted correctly, but when i try to insert the same photos in a column of merged cells (3 cells in one) 3 photos get inserted in each cell, letting me with only 17 rows of photos. I will...
  2. Z

    VBA: Merge cells based on values in a specific column

    Hi everyone, I am a student who's new to Excel VBA and need some help with my code I have a column of values in range L4:L53: 4 2 2 2 2 3 5 .... and so on What I wish to do is merge the cells starting from X4 according to the values in column L E.g. The value in L4 is 4, cells X4:X7 should...
  3. U

    VBA: Copy Paste Data with Merge Cells

    Hi Gurus, Good day! Could you provide your insight on how the macro can paste the data from a worksheet to another with merge cells? Workflow: 1. I have a main data worksheet and files to update. Files to update on this case is same with State provided in Source worksheet. All State data...
  4. D

    run time error 1004 cant do this to merge cells

    Hello, i am getting a run time error we cant do this to merged cells. e29 is merged so using columns E and F and the then what the code is doing is pasting the formula into that cells. Then trying to copy the formula paste it into the cells basically repasting it into e29 when "I" is one then...
  5. S

    Merging multiple lines into 1 based on common cell info (Name) on each line

    Hoping someone can help with this. I do scheduling. I download a report into Excel that has multiple rows per employee. The number of rows per employee may vary for each download (usually not over 200 lines per report). I'm looking for a way to combine the information from each employee row into...
  6. R

    Textbox with formula only show several line of text, while merged cells display whole

    Hi, i'd like to asked, is this the limit of how many line textbox could show text with a formula linked to a cell? on the left is my merged cell showing all the lines, while on the right is my textbox not showing just like my merged cells. can anyone explain? or is there any turn around hint?
  7. K

    Merge cells data convert into unmerge form

    Dear Experts, Can anyone explain, how can we change merge cells into unmerge form with exact data cell to cell. Moreover, Please note my attachment is not showing image here when i am attaching. Looking forward for your kind response, Best Regard, Kamran
  8. A

    Macro works in Excel 2013 but not in 2016, Run-time error '1004'

    I am a complete noob to VBA. We have a macro that runs fine on Excel 2013 but gets a Run-time error on 2016. The part of the macro where it hangs up is trying to copy and paste merged cells. The error states "To do this, all merged cells need to be the same size." They are the same size. It...
  9. S

    Merge all cells before an empty cell in a column

    Hi I have the below table: <tbody> OrderID Price 1 $18 1 $18 1 $18 2 $16 3 $20 4 $12 4 $12 4 $12 </tbody> Now, I want to merge values in the column Price for duplicate values in Order ID, like below: <tbody> OrderID Price 1 $18 1 1 2 $16 3 $20 4 $12 4 4...
  10. S

    Excel VBA: Merging cells in several columns based on the cell values of one column with some exceptions

    Hello, I'm using the following code from a previous post: Excel VBA: Merging cells in several columns based on the cell values of one column Option Explicit Sub MergeCellsBasedOnColumnRValues() Dim lX As Long, lMergeStart As Long Dim vMergeStartValue As Variant...
  11. J

    Find Value - Merge the 15 cells to the right

    Hello, I am using the code below to loop through all of my sheets, find the sheets that are named "Labor BOE...", then find the text "Method of Quoting:" within column B, and resize this row. I was also hoping to merge the 15 cells to the right... so this would mean it would find "method of...
  12. O

    VBA for edit text and remove blank rows

    I m finding out VBA for merging text with a space from below cells which has blank at the next column , and then remove the row that has blanks, as shown below.:confused: First Form <colgroup><col span="2"><col><col><col><col><col></colgroup><tbody> 1 1.500WT - PIPE SSAWL API 5L BE 30...
  13. A

    Filtering Tables with Merged Cells to Show Whole Merged Cell

    I have often had tables with merged cells and I want to filter them but see all rows that are part of the merged cells. I wrote a macro to do this. I could not find something similar while Googling, so decided to post here for others. I found a guide here that shows how to do it manually. I...
  14. T

    Values repopulate after an umerge operation, possible?

    Hi, First time poster here and I was hoping someone could explain the apparent anomaly I'm currently experiencing. The Background. We have blackbox program that reads a user defined Excel (office 2010 Excel v14) range and converts it to XML and displays it in Word(2010). While the import...
  15. D

    Conditional formatting deleted when un-merging cells

    Hi, First of all. Thanks to anyone that might answer my question. I love this forum and have searched it many times for answers to all sorts of excel related question. However, this time around I could not find the answer. If this has been answered previously, I apologize for bringing it up...
  16. A

    copying cell A1, 10 characters into cell B1 - Partial merging

    HI, i have look but not sure the correct terms of what i need I have some urls i need to redirect for my site and there are hundreds and i wondered if it possible to take whatever is in column A, and paste it 10 characters into column B e.g., Cell A1 is pasted directly after Redirect / in...
  17. S

    How can I get text on merged cells to align with single-cells in Excel 2010?

    Hello, I'm working on a dynamic spreadsheet in Excel 2010. It is a bylaws amendment document, and so each line has to be numbered. I used a center column to display the ongoing numbers. On either side, I have merged cells so that every paragraph could be in one merged cell together, but I want...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top