Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I guess maybe i should have mentioned that myMsg goes to the .body of an
email. Still get the spaces with the below suggestions...any other thoughts? The space isnt in the cell... I think the spaces might be coming from the email program (I notice them when I copy/paste from email messages). What if you apply the RTrim function to the email lines that you end up concatenating vbNewLine onto. I think like this may do for you.... myMsg = myMsg & myCell.Offset(0, -2).Value & _ " Millwork: " & RTrim(myCell.Value) & vbNewLine and maybe here too... myMsg = RTrim(myMsg) & vbNewLine Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete extra space | Excel Worksheet Functions | |||
Extra Line Space | Excel Discussion (Misc queries) | |||
Extra Line Space | Excel Discussion (Misc queries) | |||
Extra line space | Excel Discussion (Misc queries) | |||
extra space | Excel Programming |