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
Next
> Cells(H, C + 1).Value = "'" & st
> st = ""
> Next
> Range("A1").Resize(ActiveSheet.UsedRange.Rows.Count,
> ActiveSheet.UsedRange.Columns.Count - 1).Columns.Delete
>
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
Thanks, Rajan - we're getting closer, I can almost see it ..i
wanted an output that shows all the combinations of 0 and 1 using 7
digits.
The output looks like:
0101010
010
0001000
001
1010101
000
1101100
0110011
..and this list goes on for a total of 2 ^ 7 times = 128
Try This
Sub MakeCombination()
Dim Zero As Integer
Dim One As Integer
Zero = Range("A1").Value
One = Range("B1").Value
Dim Combination As Integer
Combination = Range("C1").Value
Dim st As String
For i = Combination To 1 Step -1
st = WorksheetFunction.Rept(Zero, Combination)
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
