Announcement

Collapse
No announcement yet.

Data Not Overlapping Next Cell

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Data Not Overlapping Next Cell



    This is probably a simple fix, but I cannot figure out why some of my data will overlap over the next cell if it is bigger than the cell width and then some will not, I just get ###### error. There is nothing in the next cell. I don't want to increase the cell size because that would mess up the rest of my page format. I've also tried to merge two cells together, but then it causes an error in my macro, even though the cell name is the same.

  • #2
    Re: Data Not Overlapping Next Cell

    Try selecting the cells and setting the Alignment property to CenterAcrossSelection.

    Comment


    • #3


      Re: Data Not Overlapping Next Cell

      CenterAcrossSelection did not work. I found out that numbers do not overlap, but text does. In these particular cells, I put in ID numbers so they usually have some text in them and are not a problem. In the rare event I have just a number I will have to remember to use a ' in front. I guess I will just have to use this solution for now.

      Comment

      Working...
      X