| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Using Spaces()
I am trying to use the following line of code to produce equally spaced
columns of text. Headers = H1 & Space(10 - Len(H1)) & H2 & Space(20 - Len(H2)) & H3 & Space(10 - Len(H3)) & H4 & Space(10 - Len(H4)) & H5 & Space(8 - Len(H5)) & H6 & Space(12 - Len(H6)) & H7 & Space(12 - Len(H7)) & H8 Headers is a string variable H1-8 are string column titles the number after Space( represents the total width I want that column to be I am trying to dump data parsed from a query into columns in a text email. I want to stay away from HTML. Why isn't this working or is there another way? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel file get error with file names that have spaces in the | Setting up and Configuration of Excel | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| spaces not recognized as spaces | Excel Worksheet Functions | |||
| Help copying a range with spaces to a range without spaces | Excel Programming | |||
| Spaces | Excel Programming | |||
Threaded Mode
