Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread Erick C
quot;, 6 - Len(Cells(R, 33).Value)) > > Paul > > ________________ > From: Erick C > To: MS EXCEL AND VBA MACROS > Sent: Fri, January 7, 2011 10:10:09 AM > Subject: $$Excel-Macros$$ Need Help Getting Text To Align Left > > Hello everybody, > > I am

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread Paul Schreiner
t = StrOut & StrDelim _ & Cells(R, 33).Value & _ Application.WorksheetFunction.Rept(" ", 6 - Len(Cells(R, 33).Value)) Paul From: Erick C To: MS EXCEL AND VBA MACROS Sent: Fri, January 7, 2011 10:10:09 AM Subject: $$Excel-Macros$$ Need Help Getting Text To Align Left

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread ashish koul
can you attach the sample sheet On Fri, Jan 7, 2011 at 8:40 PM, Erick C wrote: > Hello everybody, > > I am in desperate need of some assistance, and I am hoping someone may > be able to give me a hand. I am still a bit of a novice when it comes > to vba code writing, so I am hoping that it may

$$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread Erick C
Hello everybody, I am in desperate need of some assistance, and I am hoping someone may be able to give me a hand. I am still a bit of a novice when it comes to vba code writing, so I am hoping that it may just be something that I am not aware of. I have some code that makes a string of text usin