falls 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$
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
ount
R = ActiveSheet.UsedRange.Rows.Count
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" wrote:
> Hi Try This
>
> Sub MakeCobmination()
>
> Application.ScreenUpdating = False
> Dim t As Dou
times = 128
different combinations
Appreciate your help in getting me to my goal !
best,
Financeguy
On Jul 10, 12:26 pm, "Rajan_Verma" wrote:
> Try This
>
> Sub MakeCombination()
>
> Dim Zero As Integer
>
> Dim One As Integer
>
> Zero = Range("
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
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
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()
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 th
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 in
10 matches
Mail list logo
