merged cell

  1. C

    How to centre image in merged cells

    Hello all. I require a little guidance on how to centre an image within 2 merged cells the code I have been using to centre an image in one cell does not work for 2 cells. No matter how I try I just cant get it to work. Is there a way to alter the code to allow for this. See bellow for the code...
  2. A

    Rookie needing help with Macros and formula assistance

    Hello I am pretty much a VBA rookie, but learning a lot in the last month so please talk to me like I am six and explain as much as possible :) I had a thought about putting in a couple macros depending on if a cell is blank or has an "X" I want to have a macro ran depending on which option is...
  3. L

    Counting merged Cells based on criteria

    Hi, I have read a lot of forums discussing merged cells and how to calculate the number of merged cells based on the criteria given, however the formula below only returns the number of merged cells for the first set of merged cells and not for the entire column. If I wanted to count the number...
  4. J

    Target.Address is a merged cell

    Hi, I am struggling with the VBA code below. The code works fine until I delete the contents of the target cell, this does not have the desired effect of hiding the row below. I believe this is due to the target cell B315 being merged with B316. Any ideas how I can rectify this? Thanks, Justin...
  5. B

    Fill Down With Merged Cells

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

    Copy/paste Row 1 after every merged cell

    Hey Guys! Im looking for a VBA code that will copy row 1 from column A to M , and will paste row 1, a line below every time it finds a merged cell. And I want this to loop until the last Merged cell. Please refer to my code below and see if it makes any sense to you. Can someone please help...
  7. A

    Failing Automatic Row Height for Merged Cells with Text Wrap

    Excel Friends, Th procedure Automatic Row Height for Merged Cells below works for me, but partially. It changes to the Row Height but not all the times. No evident reason. Most of the times I modify the length of the text, hit Enter and nothing happens. So, after hitting Enter I go back up to...
  8. 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...
  9. I

    Spell check either Active X text box, text box or merged cells in excel 2016

    I hope someone can help me. I have a protected workbook with protected work sheets (2016). I built the spreadsheet with merged cells for user comments, but have now been asked to allow spell check in the comments field. In the example below I would need a text box/merged cell from b2:e3 (with...
  10. C

    Large Dependent Data Validation, 1 Range, Multiple Values

    Hello All, I have UTFSE however i really am having difficulty explaining this issue so please bear with me. I have a list of products and its used for Data Validation, the idea is i can just select the product name, the next step is to be offered a list that will only show me the relevant...
  11. O

    Extracting multiple entries in a single merged cell to individual row

    Hell everyone! This is my first time posting on this forum, but I have a fairly basic question. I have received a data dump with multiple values in a single merged cell that I need to extract into individual rows so I can preform a vlookup on this data. It looks like this expect on a much...
  12. J

    Name of Merged Cells

    I am stumped! I have a good level of VB experience and have combed through VBA posts for answers but this one is beating me. Here is where I am at: - Merged 4 cells together (A1:B2) - Renamed merged cells "SampleBlock" - Select the range "SampleBlock" with the cursor so that it is the active...
  13. D

    Printing issue - text cut off in the middle of a merged cell

    Hello I have an excel workbook as a dashboard. One area is for comments and is a combined set of cells (merged/ text wrapped etc) Visually all looks fine as it does in print preview. Even converted to PDF it looks fine. the Problem is prining. When you print certain lines cut the text off...
  14. M

    Cannot change a part of a merged cell (cell is not merged, I am not copying or pasting)

    I have a spreadsheet that an admin goes into on a daily basis and manually enters data in every cell down a column. About every other cell she gets the error, "Cannot change part of a merged cell." I am confused because the cells in the column are not merged. She is not copying or pasting...
  15. T

    VBA to resize merged cells textboxes

    Please help me with this, I've been looking for a good solution to this for ages! I'm trying to create a macro which runs and resizes merged cell text boxes to fit the text within them. I found this code online on a different forum, which was working (albeit very slowly) a few days ago...
  16. L

    Check if merged cells are blank

    I have an Excel 2003 spreadsheet containing a mix of UK date and currency formatted cells. I cannot change the structure of the spreadsheet. In VBA, during a worksheet change event, I want to check if the user has deleted the data from a number of ranges comprised of merged cells. If the user...
  17. E

    auto Filter a merged cell

    hi Please confirm that I cannot filter a merged cell in excel 2010? cheers RM
  18. L

    Automaticaly expand merged cells height

    Hi, How can I set merged cells (with wrap text option activated) to automatically expand when current height is exceeded ? I've unsuccessfully tried many ways. Can somebody help ? :confused:
  19. E

    Data Validations Circles aroung Merged Cells

    I have data entry validations set for some merged cells. However, when I click the "Circle Invalid Data", it circles the merged cell and all individual cells. Is there any way to circle only the merged cell and not the individual cells with it? Thanks in advance!!! :)
  20. M

    Merged cells won't alphabetize

    I've merged each group of 5 rows of Column B to make a larger text box. Other columns don't have merged rows. There's a header row with titles for the columns that has an up-down arrow to alphabetize A-Z or Z-A or numerically. When I try to use this feature, I get an error message: "All...

Some videos you may like

This Week's Hot Topics

Top