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:
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-
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
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
...@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
StrArray = Split(Range("A" & R).Value, ";")
>* For C = 0 To UBound(StrArray)
>* Cells(R, C + 1).Value = StrArray(C)
> Next C
>Next R
>Application.ScreenUpdating = True
>
>and it worked almost instantaneously instead of all the
>screen "fl
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:
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
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
tead of all the
screen "flashing" that goes on with TextToColumns.
Paul
From: Jorge Marques
To: excel-macros@googlegroups.com
Sent: Thu, February 10, 2011 6:46:37 AM
Subject: $$Excel-Macros$$ Macro issue passing values from Cell to columns
Hi, i have a macro i´ve done, but it 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:
>
Hi, i have a macro i´ve done, but it it has a problem, when it passes the
data from cells A to various columns it stops no cell 20 in the sheet2 e the
another stops at another cell number, i have the file attached here with the
code below, can´t seem to discover the error, taking baby steps at this
12 matches
Mail list logo
