Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create a link for both content and format of the cell?
When I insert a link to a cell in Excell, the destination cell shows data
content but not the format of the source cell. How do I create a link so that the destination cell shows both data content and format of the source cell? Thank you for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create a link for both content and format of the cell?
Linking only picks up the value of the source cell. It is possible, using
VBA to determine if a cell is a link, reach back to the source, copy the format and paste it back into the destination cell: Sub format_painter() Dim r, r2 As Range Dim s As String Dim b As Boolean For Each r In Selection If r.HasFormula Then s = r.Formula s = Right(s, Len(s) - 1) On Error Resume Next Set r2 = Range(s) On Error GoTo 0 b = Not r2 Is Nothing If b Then r2.Copy r.PasteSpecial Paste:=xlPasteFormats End If End If Next End Sub -- Gary's Student "Becky" wrote: When I insert a link to a cell in Excell, the destination cell shows data content but not the format of the source cell. How do I create a link so that the destination cell shows both data content and format of the source cell? Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
Pick up format from another cell | Excel Discussion (Misc queries) | |||
Conditional Formatting if cell content is a formula | Excel Worksheet Functions | |||
replace one tag in content of one cell and format not changed | Excel Discussion (Misc queries) | |||
How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions |