Actually, I think I have finally put it all together... Whew!
Sub NewNotes()
'This macro readies my note cell for entering notes by copying the old notes to the cell that keeps the old notes.
Dim Numchars As Long, s As String
Numchars = InStr(1, ActiveCell, "ACTION:", vbTextCompare)
If Numchars <> 0 Then
cText = Left(ActiveCell, Numchars - 1)
With ActiveCell.Offset(0, 3)
.Value = cText & Chr(13) & .Value
End With
End If
Dim rng2 As Range
Dim rng As Range
Dim Length As Integer
Dim LeftSide As Integer
Dim RightSide As Integer
Dim StartingLength As Integer
Set rng = ActiveCell
Set rng2 = ActiveCell.Offset(0, 3)
StartingLength = Len(rng)
LeftSide = InStr(rng, "ACTION:")
RightSide = (InStr(LeftSide, rng, "ACTION:")) - 1
Length = RightSide - LeftSide
rng2.Characters(Start:=LeftSide, Length:=65535).Font.Size = 3
Dim R As Range, c As Range, lRw As Long
Set R = Selection
For Each c In R
c.Value = Format(Date, "mm/d") & ": " & Mid(c.Value, InStr(1, c.Value, Chr(10)))
c.Characters(InStr(1, c.Value, Chr(10))).Font.Bold = True
Next c
End Sub
Bookmarks