score:0
all you need to do is put quotes with a space in your concatenation like below:
strbody2 = "<b>downtime particulars</b>" & "<br>" & _
"short description: " & " " & range("external_start_description").text & "<br>" & "<br>"
score:4
html collapses runs of multiple spaces to a single space - you need to use the non-breaking space entity
if you want a run of spaces.
replace(space(10), " ", " ")
Source: stackoverflow.com
Related Query
- Add spaces to a string to be used in .HTMLBody
- How to add spaces to a string in Excel VBA
- How can I add a single quote to a VBA string used as a search and replace string in a formula?
- How to determine the last Row used in VBA including blank spaces in between
- Removing All Spaces in String
- C# Char from Int used as String - the real equivalent of VB Chr()
- VBA split string by spaces
- Split a string by comma(,) and add the objects to a collection
- Is there a way to use VBA and XML to add a button to the Office 2010 Ribbon depending on a string in the file name?
- Regex pattern for 2 or more alphabetic characters used in a group 2 or more times in a string vba
- How to correctly add "yes / no" into a VBA message box with existing string
- Variant array of String contains alternate spaces
- How can I add empty spaces between values to a vba array?
- VBA Exclude special characters and numbers but keep spaces from string
- Import txt file into excel, split string where spaces and place each word in cell
- Insert 5 rows between data change, copy one column & add text string to another
- Delete the spaces in the middle and end of a certain string from a website
- Add String to next line of the same cell in LOOP
- MS Access Form - string from textbox used for LIKE query to filter report results
- How to preserve trailing spaces in a string when printing it onto a cell?
- How to count the number of empty spaces in front of a String in VBA?
- Want to add variable to Format () String output
- Remove the commas, spaces and "NULL" string to 0(Zero) from Column
- Excel VBA: How to insert rows and add string of text
- Count the number of empty spaces in front and back of the string
- Extract string between spaces using location based on instr
- How to Identify Substring in a string without spaces
- RegEx find string containing numbers with one space, two spaces or no space at all followed by / and four numbers
- Add tab spaces to mail body
- Add 1 to a value if name is equal to a string on a different sheet
More Query from same tag
- VBA Dates: Cannot Get the Format Correct
- Dynamic Union Query with Primary Key
- saving temporary form on MS Access
- VBA OptionButton True, False or Empty
- Ignore array item if it doesn't exist in slicer items (slicer filtering with array)
- unchecking the checkbox in userform
- Increment a Sequence vba
- Store all dates between 2 dates in vba into an array
- How to avoid using Select in Excel VBA
- Returning the Line BEFORE a Table in Word
- Access-VBA Changing Font and Size of text in form
- Access 2013 maximized form
- Can you include a Jpeg or any image onto an excel form
- Delete pictures within relative selection in Excel 2013
- Change Fill Color Of Series On Chart
- ambiguous name detected : Worksheet_Change
- Reset internal sheet name back to an ascending order
- How do you skip prefilled cells and also fill in the blank cells with no duplicates?
- Creating a loop with an IF variable -- Run-time error '1004'
- Extremely slow when clearing all filters on a sheet using VBA
- Copy/Paste variable-defined range between sheets
- Populate dynamic dropdown in Excel form with VBA
- 64bit DLL works in VB.net but not in VBA
- Excel 2016 is asking for a password for running a VBA
- How can increase the calendar size in Access?
- IF returns FALSE when it sould return TRUE
- VBA Run time error '91' - cannot figure out why error is occurring
- Parse data from internet HTML page using VBA and IE
- Protect a row in Excel with a password after it was completed by user
- VBA connection string to Azure database