Format when linking cells
 

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

Format when linking cells
 

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?