Hi
function can not transfer formats. You have to apply the same format to
all rows manually

--
Regards
Frank Kabel
Frankfurt, Germany


Loroboro wrote:
Hello All,

I have a workbook with three sheets. On the three sheets are three
different forms. Currently I have it so that when i type data into
sheet1, there are cell links going to sheet2 and sheet3... and the
other two forms get parts of them filled out automatically. The
problem i have is that... the cell format is not held. I would like
the section of rows that are being edited to auto-fit and
wrap-text... Currently when i am typing in sheet1 form.. the cell
resizes but when i go to the other sheets (2 and 3) forms.. the text
just goes into the cell and keeps going out of the cell..

any ideas would be appreciated

thanks,
Lorbo

Hello

I have already applied the format, but after the i type in something on sheet 1.. the format still doesnt hold (wrap-text and row-autofit)

Perhaps there is some code to assist me with this formatting

For instance, if i type in something on sheet
then click on sheet 2..... is there a code that will automatically apply the format (wrap-text and row-auto-fit) to a certain range/rows/cells?