Below is a piece of my code:

If Cell.Offset(0, -1).Value < "Comment:" Then
WSSD.Cells(rw, "A") = Cell.Offset(0, -1)
WSSD.Cells(rw, "A").InsertIndent 3
rw = rw + 1
End If


My problem is that I want WSSD.Cells(rw,"A") to have the same format as
Cell.Offset(0,-1). However, I want to do this without copying and pasteing,
selecting or activating. Is that possible?

--
Thanks
Shawn