Carry over formatting between linked cells.

[WDS]

I have a sheet in a workbook in which I have linked to other worksheets in
the same workbook. The original cells I have linked to have specific
formatting, but it doesn't carry over into the linked cell. How do I carry
over the formatting to the linked cell?

 

[Sheeloo]

You can not unless both sheets have the same distribution of cells, then you
can paste the format over the linked cells after copying the original cells
(PASTE SPECIAL|Formats)

Othe option is through VBA...

 

[WDS]

That's what I was afraid of. Do you know how to do it in VBA? I know NOTHING
about VBA programming.

 

[Sheeloo]

To learn about macros visit
http://www.taltech.com/support/sw_tricks/exmacros.htm

The following code will copy the format from Sheet1 A1:K10
to the same cellls in Sheet2
Remove the line nos... there are just to avoid problems due to line wrap in
the post

1 Sub Macro1()
2 Sheets("Sheet1").Range("A1:K10").Copy
3 Sheets("Sheet2").Range("A1").PasteSpecial Paste:=xlPasteFormats,
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
4 End Sub