About Us

ORLANDO V[_2_]

Thank you.

"JE McGimpsey" wrote:

XL functions only return values to their calling cells, not formats.

You could, instead, use an event macro. Put this in your target (i.e.,
non Front Page) worksheet's code module:

Private Sub Worksheet_Calculate()
Dim rSource As Range
Dim rCharFont As Font
Dim i As Long

On Error GoTo ExitSub
With Application
.ScreenUpdating = False
.EnableEvents = False
End With
Set rSource = Worksheets("Front Page").Range("N43")
With Range("A1") 'Change to suit
.NumberFormat = "@"
.Value = rSource.Text
For i = 1 To Len(.Text)
Set rCharFont = rSource.Characters(i, 1).Font
With .Characters(i, 1).Font
.Name = rCharFont.Name
.FontStyle = rCharFont.FontStyle
.Size = rCharFont.Size
.Color = rCharFont.Color
If rCharFont.Subscript Then .Subscript = True
If rCharFont.Superscript Then .Superscript = True
.Underline = rCharFont.Underline
.Shadow = rCharFont.Shadow
.OutlineFont = rCharFont.OutlineFont
.Strikethrough = rCharFont.Strikethrough
End With
Next i
End With
ExitSub:
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub

In article ,
ORLANDO V wrote:

Is there a way to change the format of how individual characters appear in a
linked cell while maintaining the link?

For example my link: ='Front page'!N43
should equal: 4.6[2] where [2] equals a superscripted 2 colored blue.
(unable to dupe this here hence [2].)

Please let me know.
Thank you.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I have a linked cell auto-size to fit the linked data?	CristinPDX	Excel Discussion (Misc queries)	0	June 24th 08 08:42 PM
Linked cells limited to ~253 characters unless source file open	ScottFisher2004	Excel Worksheet Functions	3	June 24th 08 03:40 PM
# of characters visible from a linked cell	veryeavy	Excel Discussion (Misc queries)	1	October 12th 07 01:48 AM
using wildcard characters for filenames in externally linked files	Harold Good	Excel Discussion (Misc queries)	0	June 27th 06 03:40 AM
Why is a linked cell restricted to 256 characters	Excel help needed	Excel Discussion (Misc queries)	4	February 16th 05 12:58 AM

Menu

About Us