Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-14 Thread Jorge Marques
ut is that what you mean? > What do you want to the do with the value already in column "C"? > > Paul > > -------------- > *From:* Jorge Marques > *To:* excel-macros@googlegroups.com > *Sent:* Sun, February 13, 2011 10:54:40 AM > > *Subject:* Re:

OT Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-14 Thread Paul Schreiner
sing a loop? Sorry, but my knowledge of arrays in VBA is very limited. Regards - Dave.   ____ Date: Sat, 12 Feb 2011 09:20:50 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns To: excel-macros@googlegroups.com It's like the text-

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-14 Thread Paul Schreiner
a loop... but is that what you mean? What do you want to the do with the value already in column "C"? Paul From: Jorge Marques To: excel-macros@googlegroups.com Sent: Sun, February 13, 2011 10:54:40 AM Subject: Re: $$Excel-Macros$$ Macro issue passin

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-13 Thread Jorge Marques
of it. If you have time, could you please explain >> that part? >> Regards - Dave. >> >> -- >> Date: Fri, 11 Feb 2011 06:15:45 -0800 >> From: schreiner_p...@att.net >> Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to

RE: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Dave Bonallack
...@att.net Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns To: excel-macros@googlegroups.com It's like the text-to-columns in Excel 2007. If you have a string: "The Quick Brown Fox jumped over the lazy dog" and you wanted to store the words in

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Paul Schreiner
I'm not sure what you mean by "the last A goes to the first B". Can you give an example? Paul From: Jorge Marques To: excel-macros@googlegroups.com Sent: Sat, February 12, 2011 9:47:21 AM Subject: Re: $$Excel-Macros$$ Macro issue passing valu

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Paul Schreiner
rse ubound(StrArray) gives the upper bound of the array (8). I wrote a function LONG ago using this to accomplish what is now done with txt-to-columns in Excel2007! hope this helps, Paul ________________ From: Dave Bonallack To: "excel-macros@googlegroups.com" Sent:

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Jorge Marques
6:15:45 -0800 > From: schreiner_p...@att.net > Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to > columns > > To: excel-macros@googlegroups.com > > Curious... > Actually, the Activecell object is not necessary. > > I changed

RE: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-12 Thread Dave Bonallack
make sense of it. If you have time, could you please explain that part? Regards - Dave. Date: Fri, 11 Feb 2011 06:15:45 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns To: excel-macros@googlegroups.com Curious... Actually, the

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-11 Thread Paul Schreiner
Curious... Actually, the Activecell object is not necessary. I changed it to: If Range("A"&i) = "" then exit sub else and it worked just fine. BTW: I changed the loop to: Application.ScreenUpdating = False For R = 1 To 1000     If (Range("A" & R).Value = "") Then Exit Sub     StrArray = Split(

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

2011-02-10 Thread STDEV(i)
While '-- your macro Wend is an expression that evaluate to TRUE or FALSE Ex: yr data are in cell B4-down. i = 1 With Activesheet.Range("B4") While Len(.cell(i,1) > 0 .cell(i,1).texttocolumns destination:=.cell(i,2), '-- etc -- i = i + 1 Wend End with On 2/10/11, Jorge Marques wrote: >