xlFill

[Joey Lawerence]

What's the story with xlFill. I'm having problems finding
documentation on it. I thought if text in a cell
overlapped the next cell xlFill will cut it off at the
cell's edge. Which it does do. But I also noticed that if
the cell has little text and empty space in the cell then
xlfill will copy the text over and over till the cell is
filled. I need the text to stop at the cells edge. Any
suggestions.

 

[Steve Garman]

I'm guessing that what you're talking about is something like:
ActiveCell.HorizontalAlignment = xlFill

I don't think there is a HorizontalAlignment that truncates text, which
seems to be what you want.

You could try setting the HorizontalAlignment to xlHAlignGeneral and
making sure there is something (a space will do) in the cell to its right.