MWE
09-01-2005, 11:57 AM
If one wants to "manage" individual characters within the text of a cell, they can be referenced something like:
With TargetCell.Characters(Start:=1, Length:=6)
.Font = something
etc
End With
According to the object browser, another valid approach is:
Start = 1
Length = 6
With TargetCell.Characters(Start, Length)
etc
End With
The first method works, but the 2nd method generates errors; in particular
Run Time Error 438
Object does not support this property or method
So, what am I doing wrong?
Thanks
With TargetCell.Characters(Start:=1, Length:=6)
.Font = something
etc
End With
According to the object browser, another valid approach is:
Start = 1
Length = 6
With TargetCell.Characters(Start, Length)
etc
End With
The first method works, but the 2nd method generates errors; in particular
Run Time Error 438
Object does not support this property or method
So, what am I doing wrong?
Thanks