Attributes of a cell

  • Thread starter Thread starter Robbie
  • Start date Start date
R

Robbie

I need to allow a text string to overwite its contents to the adjacent cells
to its right. This appears to happen by default by I also need those
adjacent cells to report a text
string under certain conditions using the IF function linked to another
cell.

Under those circumstances the contents of that cell hide the contents of the
cell to its left. Is there any way of allowing the first cell to show the
whole text string when the cell to the right has no text to report.
I imagine using an IF statement but have no idea the correct code to report
no format (as if you had pressed the delete key in that cell). I am sorry
if this is confusing but I am not sure how to explain what I am trying to
achieve.

Thank you for any help in advance.
I only have a some VBA experience but am willing to try any suggestions

Robbie
 
Unfortunately if there is anything actually in a cell (whether the result is
visible or not) it blocks the text overflow of the cell to the left.
 
Back
Top