Format Of Linked Cells From Another Worksheet

[TheMus]

Hello,

I'm trying to retain the "Wrap Text" cell format when I link a cell to another worksheet but it's not working. Both cells, the source cell and the linked cell, are formatted with wrap text. Any ideas how I can retain the format from the source cell to the linked cell?

Thanks,

Rus

 

[LSTAN]

Hi

You can placed the below code at the targeted worksheet's Change event.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = True
End With
End Sub

This code will text wrap the cell contents if deem necessary.

Hope this will helps.

Regards

LSTAN