Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My VBA is Microsoft Visual Basic 6.3, from Excel 2003 (11.6535.6360) SP1
from XP Professional Version 2002 SP3. Google groups tells me cells do not sensibly display tab characters. I have some cells where each cell contains a small set of information. I want vertical alignment of such information. An example of such data is: 29 Mar 09 29 Mar 09 Central Liverpool Street to Leytonstone 04 Apr 09 05 Apr 09 Hammersmith & City Edgware Road to Hammersmith. If I use a fixed pitch font, such as Courier New, I can do something like Left(LineName & Spaces, Len("Hammersmith & City")) to pad the third pseudo-column to a fixed width. I am actually using Tahoma, which is a proportional font; that technique fails to deliver the desired result for proportional fonts. I have a small number of distinct values for the third column; I could roughly bludgeon something by padding from an array of spaces; I am looking for something more elegant. I have looked for terms like format and align in help, without success. (Solutions using multiple columns do not fit my criteria. ;( ) (This posting will be distorted, if read in a proportional font ;) -- Walter Briscoe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simulating a Zodiac with a chart | Charts and Charting in Excel | |||
How do I select specific cells to be my tab stops? | Excel Worksheet Functions | |||
same than end(xldown) but stops on hidden cells if not empty | Excel Programming | |||
iValue Stops after 10 cells of data | Excel Programming | |||
Simulating HTML frames inside a Excel application | Excel Programming |