You can stop the bleed over into the adjacent cell by putting something in that
adjacent cell. If you want it to look empty, I'd use a formula:
=""

It looks empty, but reminds me that I put something there on purpose.

(you could use a space character, but those are too difficult to distiguish for
me.)

If you use a Courier New font (fixed width), you could even truncate the
contents when you populate that cell.

mycell.value = right(myothercell.value,32)

But this doesn't work so well if you you're using non-proportional fonts--it's
difficult to guess how many characters will fit.



Johan Christensson wrote:

Hi.

I have a customer that has a Excel form that the fill out, and they want to
print this onto a pre-printed form using a dot matrix printer.

I worked out a VBA that takes the values from the form and passes them into
a nother sheet, and by adjusting the hight and width of the cells I can
predict where the text is going to end up in the printer. How ever. The
problem with this method is that I can't predict how many characters a
certin field is made up of form time to time, and this makes the possition
shift.

So is it possibel to instruct Excel to place a certin value at an XY
position, and/or stop cells size of infuensing on other fileds.

/Johan Christensson

--

Dave Peterson