within a certain period in Column T
=IF(A5=$T$5,$S$5,IF(AND(A5$T$5,A5=$T$6),$S$6,IF(AND(A5$T$6,A5=$T
$7),$S$7,IF(AND(A5$T$7,A5=$T$8),$S$8,IF(AND(A5$T$8,A5=$T$9),$S
$9,IF(AND(A5$T$9,A5=$T$10),$S$10,))
many thanks,
Financeguy
@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 at:
Range(A Range(A65536).End(xlUp).Row +
1).Resize
Is is because im using MS Excel 2003? or can it be easily fixed.
Thanks again,
Financeguy
On Jul 11, 3:40 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Hi Try This
Sub MakeCobmination()
Application.ScreenUpdating = False
Dim t As Double
Dim Digit As Double
Dim SS
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 koul.ash
= 128
different combinations
Appreciate your help in getting me to my goal !
best,
Financeguy
On Jul 10, 12:26 pm, Rajan_Verma rajanverma1...@gmail.com wrote:
Try This
Sub MakeCombination()
Dim Zero As Integer
Dim One As Integer
Zero = Range(A1).Value
One = Range(B1).Value
Dim
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
Hi All,
I've got some code that's a bit buggy for a stock analysis
spreadsheet, and in need of some help. For some reason, I experience
an error at If Cells(6 + i, 12) Then and would appreciate
any help in fixing it. Many thanks for your help in advance.
Best, V
_
Sub List()
Dim i
Hi,
I'm trying to select one range at a time for each individual column
within a single worksheet. I have range data in approximately 150
columns on the worksheet that I would like to sort individually
(ascending order), then cut, and finally paste into the last row of
Column A.
For example, if
I have a spreadsheet in which column A and B have date valuesfor
instance A1 will have Jan 30, 2005 and B1 will be March 8, 2005.
Corresponding to each range of dates in A and B, I have a value, lets
say Alpha in Cell C1. These date ranges in A and B columns and code
in C repeats for row 1
I would like to execute a batch routine using VBA from an Excel file,
to be able to call various Excel files in a folder and copy cells from
sheet name assumptions range A1:Z1000 into a new tab from where I am
executing the batch.The objective is to pull data from multiple
files in a folder
10 matches
Mail list logo