m: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of Financeguy
> Sent: Wednesday, July 13, 2011 2:09 AM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Binary Combinations Using VBA
>
> Hi,
>
> This works really
Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Financeguy
Sent: Wednesday, July 13, 2011 2:09 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Binary Combinations Using VBA
Hi,
This works really well, except it shows an error a
Range("C1").Value
>
> > Dim st As String
>
> > For i = Combination To 1 Step -1
>
> > st = WorksheetFunction.Rept(Zero, Combination)
>
> > st = WorksheetFunction.Substitute(st, Zero, One, i)
>
> > Range("H" & Combination - i
l-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Financeguy
Sent: Monday, July 11, 2011 1:28 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Binary Combinations Using VBA
Thanks, Rajan - we're getting closer, I can almost see it ..i
wanted an output t
etFunction.Substitute(st, Zero, One, i)
>
> Range("H" & Combination - i + 1).Value = "'" & st
>
> Next
>
> End Sub
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Financeguy
> Sent: Su
Financeguy
Sent: Sunday, July 10, 2011 9:28 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Binary Combinations Using VBA
Hi All,
I'm trying to generate a list of binary combinations as follows:
cell A1: 0
cell A2: 1
cell A3: 7
I'm requesting help to create
Unfortunately, Im not sure how this works with what Im trying to
achieve. Appreciate your help.
Anyone else know how to develop a macro that accomplishes generating
binary numbers based on the possible combinations, please help.
Thanks,
Financeguy
On Jul 10, 1:06 am, ashish koul wrote:
> try
try this
http://www.visualbasic.happycodings.com/Applications-VBA/code4.html
On Sun, Jul 10, 2011 at 9:28 AM, Financeguy wrote:
> Hi All,
>
> I'm trying to generate a list of binary combinations as follows:
>
> cell A1: 0
> cell A2: 1
>
> cell A3: 7
>
>
> I'm requesting help to create the follo
Hi All,
I'm trying to generate a list of binary combinations as follows:
cell A1: 0
cell A2: 1
cell A3: 7
I'm requesting help to create the following output in separate columns using
VBA:
0 0 0 0 0 0 1
0 0 0 0 0 1 0
0 0 0 0 1 0 0
and so on.. for a total of 2 ^ 7 times in columns A throu
