| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
Hi Howard,
Am Mon, 17 Mar 2014 15:20:17 -0700 (PDT) schrieb L. Howard: So I'm thinking that is done here where the space " " is replaced with nothing "" and if still greater than 0 it means there is text so it reads it into the array. If Len(Replace(Tlt.Offset(0, i), " ", "")) 0 Then ReDim Preserve arrOut(j) arrOut(j) = Tlt.Offset(0, i) j = j + 1 End If yes, that is the only change I made Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting blanks as spaces | Charts and Charting in Excel | |||
| Issue removing leading and lagging spaces | Excel Programming | |||
| How to count blanks and spaces that look like blanks | Excel Programming | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Threaded Mode
