In index formula we are using index(array,1,0). Means whole 1st row is
selected, in this case 1st row has 1,2,3. So there is no increment but
formula is passing values all first row value to array..
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 5, 2014 a
Hey vabz ,
Even a selected range can also be considered as an array. Can a range
variable work ???
Join(Application.Index(c01.Value,1,0), "|")
Next step
Join(Application.Index({1,2,3},1,0), "|") how it is selecting 2 even there
is no increment is going on
Join can combine the array values
Thanks Broo. Have you got your MVP award :)
On Thursday, November 13, 2014 2:47:19 PM UTC+5:30, Mandeep Baluja wrote:
>
> Please explain the last line !! What's going on in that line what is \b
> ?? etc etc
>
> Set re = CreateObject("vbscript.regexp")
> re.IgnoreCase = True
> re.Global = True
