merged

Hi I have used this site for ages now and cannot begin to tell how much I have learned. But I just cannot find a answer to a VBA problem I have. I pull a report from a 3rd party in Excel format and make changes to the page to include extra information. In one section (List Items), I want to...

I have been working on a spreadsheet for a while and I am getting an error on one of my macros. "Can't do that to a merged cell". I do not have any merged cells. Is there any way for me to attach a file so someone can help me figure this out? I'm sure it is something simple, but I am pulling...

Hi - Just a general question, as I'm confused about this. A while ago I created a macro with the macro recorder that uses relative references. I was able to clear the contents of merged cells while using that macro and didn't think anything of it, as it worked as expected. Example (where...

The condition is that in Column A, if the cell (A1,A2,A3....) is a merged cell, then delete the entire row and the row above this cell I know how to delete one entire row but I duplicate the language when trying to delete the 2nd row (can I put them together?) Sub test() Dim i As Integer For...

I'm merging Excel data to either Word or Publisher to create a set of reports. Each report includes a pie chart. I'm trying to avoid copy/paste. Can the already created chart be merged to the report? Can the data be merged to the report and auto create the chart? I think I've seen it done with...

Hi all!! I have a database that I have been using and updating for a while now and started having issues after adding another column of information to the database but can't figure out whats going on! I would attach a test copy of it for your use but there is no upload option! Let me know what...

I am trying to copy data from a group of workbooks to a master workbook but have run into a problem where the source files data are in different cells depending on individual workbook. so is there a way I can search for the string "Date:-" which appears in a group of merged cells, then return...

Win 10 / Excel 2016 Hi all, I'm having an issue with some code whereby i seem to be unable to detect the border color of merged cells. I'm using the following code: I'm looping through each range (Rng) in Worksheet.UsedRange but the first IF statement always returns 0. If Rng.MergeCells =...

I have tried a lot of different code that does not work. What I am looking to do is this: I have an excel template that users should not be able to edit the top portion of a form but they need to be able to add comments to the bottom portion of the form, to do this I have protected the sheet...

I have Column AH which has every two rows merged (AH10:AH111,AH12:AH13) etc. In column AQ I have an equation that I want to be able to fill down that references column AH. My issue is that the first cell in Column AQ references the merged cell, but the second references only half the merged...

Hello all, First time posting in an Excel forum and I have been racking my brain for the last two days trying to get this to work. My goal is that I'm trying to create a summary page for all departments of a large series of information for years back. To start I want to count the number of...

Hello - I'm aware that AutoFit doesn't work with merged cells and it is best not to work with merged cells, if at all possible. However, I've done a lot of googling to find workarounds for my spreadsheet. The solution I really like uses Worksheet_Change, but I already have a Worksheet_Change...

I have F12 and G12 as merged cells in an xls file that is exported from Navision. Clicking on F12 and pressing CTRL-Space to select the whole merged area (F:G), it selects a bigger area (A:J) because of some merged cells above F12. But if I click on the column letters F and G, I can select only...

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

Can Someone help me with my project? I am beginner in Excel-Macro. I have to copy a 1 column that is a merged cell and paste it to another merged cell but in the new Sheet. Please do help me Excel-Macro Gurus..! I really need your help. ありがとうぐざいます Best Regards, Lex

I have some merged cells , namely C4 and D4. I am trying to run some code to check if the range (c4:D4) is empty and if so to have the msgbox popup and the macro end. It works fine but it continues to keep showing the Msgbox even after I have entered a contact name into the merged cells. I can...

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

Can you help me, please? I have a few rows that share a merged cell. When this merged cell is not empty, I want the rows to highlight. Currently, the formula (applied over G5:G72) is "=NOT(ISBLANK($M5))" and then fill. Works for the 11 row, but not on the other four. [/IMG] [/IMG] [/IMG]