Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - trailing blanks
I am trying to write concatenated individual cells as a record to a
file but it is trimming the trailing blanks in the cell. This is the code I have: For RowNdx = StartRow To EndRow WholeLine = "" For ColNdx = StartCol To EndCol CellValue = (Cells(RowNdx, ColNdx).Value) WholeLine = WholeLine & CellValue Next ColNdx Print #FNum, WholeLine Next RowNdx If cell1 = "Test " and cell2 = "This ". The result in the file is a record with "TestThis". How can I get it to write the record as "Test This"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate and include trailing blanks | Excel Discussion (Misc queries) | |||
macro to fill in rows with blanks | Excel Discussion (Misc queries) | |||
Fill Blanks Macro | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Trailing blanks | Excel Discussion (Misc queries) |