Consulting

Results 1 to 4 of 4

Thread: remove text from an unmerged cell

  1. #1
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location

    remove text from an unmerged cell

    I had cells that were merged and then un merged them. At the time of un merging the cells had text in them. So, I centered the text in the two un merged cells using center across selection. So now when I put my cursor in the far left cell it shows the text, making me think that is the cell the text is in.

    I have a routine that selects the cell I think the text is in and is supposed to delete it but it doesnt delete the text. So what cell is the text really in if it is centered across selection in two adjacent cells?
    Peace of mind is found in some of the strangest places.

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    Quote Originally Posted by austenr
    ...So now when I put my cursor in the far left cell it shows the text, making me think that is the cell the text is in.

    I have a routine that selects the cell I think the text is in and is supposed to delete it but it doesnt delete the text. So what cell is the text really in if it is centered across selection in two adjacent cells?
    Hi Austen,

    Presuming you mean that with the left cell selected, the value shows up in the formula bar, then yes, that's the cell that the value is stored in.

    I would suspect that the wrong cell(s) are being selected.

    Mark

  3. #3
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Thanks Mark but I double checked the cell selected.
    Peace of mind is found in some of the strangest places.

  4. #4
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    Okay, might it be possible that the wrong sheet is being referred to?

    If this is from the workbook at post #9 of http://vbaexpress.com/forum/showthread.php?t=33972 could you point out the sub/function and what sheet it should be working against?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •