merge cell

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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