Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Im having problems with the code below displaying the text on one line. E4
is reference to a date i select in the worksheet. .htmlBody = Format(Range("E4") - 2, "mm/dd") & " ECCR (Daily, MTD)" & _ Format(Range("E4") - 1, "mm/dd") & " ECCR (Daily, MTD)" & _ Format(Range("E4"), "mm/dd") & " ECCR (Daily, MTD)" The result should look like this: 08/24 ECCR (Daily, MTD) 08/25 ECCR (Daily, MTD) 08/26 ECCR (Daily, MTD) Any Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
outlook htmlbody | Excel Programming |