merged cells

I've been doing some research trying to figure out how to solve this problem, but I'm not making much headway. I have a data analysis report. We collect data on various pieces of machinery, and our program prints the numbers into its own simple report. I paste this report onto sheet two of my...

I have conditional formatting in a single cell to show a red or green status. I am looking to copy that exact formula into merged cell in another section of a spreadsheet (using the same formula and formatting as the original). When i copy & paste special - formats, the merged cell turns into...

Hello, I've searched to try and find the answer to this question but not having much joy so any help will be greatly appreciated. I'm relartively new to excel VB codes and my seemingly impossible task is shown below: * I have a list of data each one has 6 rows of data. * (Rows...

Hello forum, I read many posts on this subject. I put together the following code and have a worksheet in my Dropbox. C:\Users\EDWARD P AYERS\Dropbox file name is TEXT MERGE RESIZE This code is not perfect; it does adjust with different column widths and font sizes. It uses formulas on Sheet1...

Let me start by saying I am using Excel 2002. I want to create a summary sheet in my workbook that contains 31 other sheets. Each sheet corresponds to the day of the given month, "Day 1" "Day 2" etc. On my summary sheet I want to search every sheet for "NL" which would be located in cells...

I need to find the column after a merged range but I cannot find the right command. I thought this would work: Cells(RowFnd, y).Columns.Count but it is giving me 1 when it should be give me 5 as J through N are merged on row 65.

I have a worksheet where columns A:D are merged. I want to delete columns B:D and this works perfect when I manually select column B and then C and finally D. I have recorded this, but the macro deletes all the 4 columns. I have also tried to unmerge the columns and this also works fine...

I am making some good headway on my project now, but have just run into this snag. I have a cell that is formed by merging 5 columns and one row into one cell (A10:E10). The data in that cell (which will always be text, even if there are numbers present) needs to be copied into another merged...

Please help me with the bellow code, can some please edit so cell b3:c3 and b4:c4 need to be cleared when the button pressed. Private Sub ResetFormButton_Click() ActiveSheet.Unprotect On Error Resume Next [b3, b4, B5, b6, b7, b8, b15, b16, b26, b27, B28, B29, B31, e12, e16, f3, f4, f5...

I have a spreadsheet set up like this: A B C 1 Basic rota 09:00 13:00 2 Absence H The Absence cell (B2:C2) is a merged cell which can contain either 'H','S','T','SC' or it can be empty. Based on the contents of that cell, B1 and C1 should change...

Hi, I've been a long time guest user of these forums, but now have a problem that I can't find a ready made anwer for on here. I have a workbook containing two worksheets of staff training records. The first work sheet contains a list of names and the dates they completed various training...

Hi, I have a range where some cells are merged and some are not. I want to apply to such range a conditional formatting that will only show on merged cells. I can set two rules with the rule number one having the option "stop if true" checked but I am in trouble in finding an excel function...

Hi, I need find some word, for example, ABC in each sheet; then, create a new row to put new values. However, in column A, we have merged cells, for example: (I will dots to symbolize the merged cells) ......|123|123|123 ......|123|123|123 ABC|123|123|123 ......|123|123|123 ......|123|123|123...

Before I start yes I have merged cells!!! This was never meant to be used with macros, but the people have spoken and I dislike them :biggrin:<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe"...

Hi, Actually, I don't have a question, so I'm not exactly sure where to post this. I have no formal experience with excel, everything I know is self-taught. Love your site! I have often seen it mentioned that data cannot be stored in separate parts of a merged cell. This is not true. It...

When I copy data from one single cell to another single cell, everything is perfect. When I copy data from one single cell to a merged group of cells, I get the text, however I loose the the text colors and highlights. Somehow it appears that the merged cells loose formatting. How can I...

Hi guys, Is it possible to fill down merged cells? I want to have the days of the month in a column, but I want each day to be across three rows of merged cells, ie Monday 2nd August Is it possible to 'fill down' or some other short cut, or do I have to do it longhand? Phil.

I have an Excel spreadsheet with numerous hidden rows. I find that under normal circumstances with non-merged cells, when I press enter Excel will move down to the cell in the next visible row. It works great. However, I recently discovered that under some circumstances this is not the...

The code below works perfectly. However, I need to merge the cells in column D with the cells in column E. When I do this the code does not work. I have tried to reference the cells in both columns but have had no luck. What do I need to do? Here is my code Private Sub...

How do I split a series of cells based on commas? There is a series of data in 2 consecutive cells, with the data in each cell corresponding to the data in the adjacent cell. I need that each pair should be lined up in separate columns. Here is the example: I need to match up the SKU with the...