Re: $$Excel-Macros$$ Macro for Find

2012-11-01 Thread Shrinivas Shevde
Dear Vijay
File is not working
Regards
Shrinivas

On Tue, Oct 30, 2012 at 6:31 PM, Vijay Kr. Aggarwal <
vjaggarwal2...@gmail.com> wrote:

> Hi Shrini,
>
> First sheet:-  Raw Data
> Second Sheet :-  Criteria is given in this sheet.
> third sheet :-  Final output would be pasted here by using criteria
> from second sheet.
>
> regards,
> Vijay
>
>
> On 10/30/12, Shrinivas Shevde  wrote:
> > Dear  Rajan and ANil
>  > Sample file is already attached .
> > Dear Vijay
> > Can u explain me the file u send
> >
> > Regards
> > Shrinivas
> >
> > On Mon, Oct 29, 2012 at 7:27 PM, Vijay Kr. Aggarwal <
> > vjaggarwal2...@gmail.com> wrote:
> >
> >> Hi Shrinivas,
> >>
> >> Please check attached file. I hope this will answer your query.
> >>
> >> regards,
> >> Vijay
> >>
> >> On 10/27/12, Shrinivas Shevde  wrote:
> >> > Dear all
> >> >
> >> >
> >> >I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH
> >> Example
> >> > .-: user want to find details of " H".then macro should ask the name
> >> > and
> >> > only that details will be paste in sheet 2 Other search may be user
> >> > want
> >> > details of all the people whose age is in between 23 to 27
> >> >
> >> >
> >> >
> >> > --
> >> > Shrini
> >> >
> >> > --
> >> > Join official facebook page of this forum @
> >> > https://www.facebook.com/discussexcel
> >> >
> >> > FORUM RULES (1120+ members already BANNED for violation)
> >> >
> >> > 1) Use concise, accurate thread titles. Poor thread titles, like
> Please
> >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice
> >> will
> >> > not get quick attention or may not be answered.
> >> >
> >> > 2) Don't post a question in the thread of another member.
> >> >
> >> > 3) Don't post questions regarding breaking or bypassing any security
> >> > measure.
> >> >
> >> > 4) Acknowledge the responses you receive, good or bad.
> >> >
> >> > 5)  Cross-promotion of, or links to, forums competitive to this forum
> >> > in
> >> > signatures are prohibited.
> >> >
> >> > 6) Jobs posting is not allowed.
> >> >
> >> > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> >> > allowed.
> >> >
> >> > NOTE  : Don't ever post personal or confidential data in a workbook.
> >> Forum
> >> > owners and members are not responsible for any loss.
> >> > ---
> >> > You received this message because you are subscribed to the Google
> >> > Groups
> >> > "MS EXCEL AND VBA MACROS" group.
> >> > To post to this group, send email to excel-macros@googlegroups.com.
> >> > To unsubscribe from this group, send email to
> >> > excel-macros+unsubscr...@googlegroups.com.
> >> > Visit this group at http://groups.google.com/group/excel-macros?hl=en
> .
> >> >
> >> >
> >> >
> >>
> >>
> >> --
> >> Regards,
> >> Vijay Kumar Aggarwal
> >>
> >> --
> >> Join official facebook page of this forum @
> >> https://www.facebook.com/discussexcel
> >>
> >> FORUM RULES (1120+ members already BANNED for violation)
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> >> will not get quick attention or may not be answered.
> >>
> >> 2) Don't post a question in the thread of another member.
> >>
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >>
> >> 4) Acknowledge the responses you receive, good or bad.
> >>
> >> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> >> signatures are prohibited.
> >>
> >> 6) Jobs posting is not allowed.
> >>
> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
> >>
> >> NOTE  : Don't ever post personal or confidential data in a workbook.
> >> Forum
> >> owners and members are not responsible for any loss.
> >> ---
> >> You received this message because you are subscribed to the Google
> Groups
> >> "MS EXCEL AND VBA MACROS" group.
> >> To post to this group, send email to excel-macros@googlegroups.com.
> >> To unsubscribe from this group, send email to
> >> excel-macros+unsubscr...@googlegroups.com.
> >> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> >>
> >>
> >>
> >
> >
> > --
> > Shrini
> >
> > --
> > Join official facebook page of this forum @
> > https://www.facebook.com/discussexcel
> >
> > FORUM RULES (1120+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > 6) Jobs posting is not allowed.
> >
> > 7) Sharing copyrighted ebooks/pirated ebooks/their l

Re: $$Excel-Macros$$ Macro for Find

2012-10-30 Thread Vijay Kr. Aggarwal
Hi Shrini,

First sheet:-  Raw Data
Second Sheet :-  Criteria is given in this sheet.
third sheet :-  Final output would be pasted here by using criteria
from second sheet.

regards,
Vijay


On 10/30/12, Shrinivas Shevde  wrote:
> Dear  Rajan and ANil
> Sample file is already attached .
> Dear Vijay
> Can u explain me the file u send
>
> Regards
> Shrinivas
>
> On Mon, Oct 29, 2012 at 7:27 PM, Vijay Kr. Aggarwal <
> vjaggarwal2...@gmail.com> wrote:
>
>> Hi Shrinivas,
>>
>> Please check attached file. I hope this will answer your query.
>>
>> regards,
>> Vijay
>>
>> On 10/27/12, Shrinivas Shevde  wrote:
>> > Dear all
>> >
>> >
>> >I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH
>> Example
>> > .-: user want to find details of " H".then macro should ask the name
>> > and
>> > only that details will be paste in sheet 2 Other search may be user
>> > want
>> > details of all the people whose age is in between 23 to 27
>> >
>> >
>> >
>> > --
>> > Shrini
>> >
>> > --
>> > Join official facebook page of this forum @
>> > https://www.facebook.com/discussexcel
>> >
>> > FORUM RULES (1120+ members already BANNED for violation)
>> >
>> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will
>> > not get quick attention or may not be answered.
>> >
>> > 2) Don't post a question in the thread of another member.
>> >
>> > 3) Don't post questions regarding breaking or bypassing any security
>> > measure.
>> >
>> > 4) Acknowledge the responses you receive, good or bad.
>> >
>> > 5)  Cross-promotion of, or links to, forums competitive to this forum
>> > in
>> > signatures are prohibited.
>> >
>> > 6) Jobs posting is not allowed.
>> >
>> > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>> > allowed.
>> >
>> > NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum
>> > owners and members are not responsible for any loss.
>> > ---
>> > You received this message because you are subscribed to the Google
>> > Groups
>> > "MS EXCEL AND VBA MACROS" group.
>> > To post to this group, send email to excel-macros@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > excel-macros+unsubscr...@googlegroups.com.
>> > Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> >
>> >
>> >
>>
>>
>> --
>> Regards,
>> Vijay Kumar Aggarwal
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
> --
> Shrini
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://

Re: $$Excel-Macros$$ Macro for Find

2012-10-30 Thread Shrinivas Shevde
Dear  Rajan and ANil
Sample file is already attached .
Dear Vijay
Can u explain me the file u send

Regards
Shrinivas

On Mon, Oct 29, 2012 at 7:27 PM, Vijay Kr. Aggarwal <
vjaggarwal2...@gmail.com> wrote:

> Hi Shrinivas,
>
> Please check attached file. I hope this will answer your query.
>
> regards,
> Vijay
>
> On 10/27/12, Shrinivas Shevde  wrote:
> > Dear all
> >
> >
> >I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH
> Example
> > .-: user want to find details of " H".then macro should ask the name and
> > only that details will be paste in sheet 2 Other search may be user want
> > details of all the people whose age is in between 23 to 27
> >
> >
> >
> > --
> > Shrini
> >
> > --
> > Join official facebook page of this forum @
> > https://www.facebook.com/discussexcel
> >
> > FORUM RULES (1120+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > 6) Jobs posting is not allowed.
> >
> > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
> >
> > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > owners and members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND VBA MACROS" group.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > To unsubscribe from this group, send email to
> > excel-macros+unsubscr...@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> >
> >
> >
>
>
> --
> Regards,
> Vijay Kumar Aggarwal
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>


-- 
Shrini

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Re: $$Excel-Macros$$ Macro for Find

2012-10-29 Thread Vijay Kr. Aggarwal
Hi Shrinivas,

Please check attached file. I hope this will answer your query.

regards,
Vijay

On 10/27/12, Shrinivas Shevde  wrote:
> Dear all
>
>
>I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example
> .-: user want to find details of " H".then macro should ask the name and
> only that details will be paste in sheet 2 Other search may be user want
> details of all the people whose age is in between 23 to 27
>
>
>
> --
> Shrini
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>


-- 
Regards,
Vijay Kumar Aggarwal

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Macro .xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12


Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-05 Thread Markkim
Thanks a lot!!!

Well, I looked at the macro and its' not what I want. 

I thought through and came up with a following code..  ( just testing code) 

In this example, there are five values: 12.25, 10.3, 24.3, 23.19, 55.2
And I need to find any combination of values above which sum up to ... let's 
say 34.6. 

Sub Test()

Dim Ob_N(1 To 5) As Variant

Ob_N(1) = 12.25
Ob_N(2) = 10.3
Ob_N(3) = 24.3
Ob_N(4) = 23.19
Ob_N(5) = 55.2


Seeking_sum_amount = 34.6

For i = 1 To 5

For j = i + 1 To 5

If Ob_N(i) + Ob_N(j) = Seeking_sum_amount Then

ActiveCell.Value = Ob_N(i)
ActiveCell.Offset(0, 1) = Ob_N(j)
ActiveCell.Offset(1, 0).Select
End If

Next
Next
End Sub

Now, the problem of this testing code is that it only looks at the 
combination of 2 values... 
I can add another for...next for three combination ...   
and add another for four 4 combination test 

but I'm wondering  if there is a way to do up to 4 combination test if 
number of given values are 4.. if number of given values is 6 then up to 
5 combination test..  and so on..  

To sum up, macro determines how many values are given.  --->  ubound(Ob_n) 
run the combination test up to ubound(ob_n) - 1 and find any combination 
which sum up to a specified value. 

any good way of doing this??? 


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-04 Thread Markkim
Hi!  siti Vi

I tried to download the example workbook but no file found 

could you send me the file if you can please???  

Thanks


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-04 Thread Markkim
Well, I haven't tried but looks like it's exactly what I want

Thanks Million

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-03 Thread STDEV(i)
you are talking about *Permutation*

given number : 1 2 3 4 5
total arrangement of permutation  *=FACT(5)* =  *120*

==
12345 21345 31245 41235 51234
12354 21354 31254 41253 51243
12435 21435 31425 41325 51324
12453 21453 31452 41352 51342
12534 21534 31524 41523 51423
12543 21543 31542 41532 51432
13245 23145 32145 42135 52134
13254 23154 32154 42153 52143
13425 23415 32415 42315 52314
13452 23451 32451 42351 52341
13524 23514 32514 42513 52413
13542 23541 32541 42531 52431
14235 24135 34125 43125 53124
14253 24153 34152 43152 53142
14325 24315 34215 43215 53214
14352 24351 34251 43251 53241
14523 24513 34512 43512 53412
14532 24531 34521 43521 53421
15234 25134 35124 45123 54123
15243 25143 35142 45132 54132
15324 25314 35214 45213 54213
15342 25341 35241 45231 54231
15423 25413 35412 45312 54312
15432 25431 35421 45321 54321
==


' VBA CODE:
'-
Dim D() As String  ' =Array Data Characters
Dim N   As Byte' =number of char
Dim Tulis   As Range   ' =range where output data to be written
Dim oRowAs Long' =Row index for Output
Dim oColAs Byte' =COlumn index for Output
Dim MaxRow  As Long' =oRow when reaching Fact(N-1)


Sub PermutArranger_Jilid3()
   '--
   ' this procedure is only preparing variables & inisials, and
   ' calling "ArrangeAndWrite" (main procedur) for the first time
   '--
   Dim k As Byte

   oRow = 0: oCol = 1
   N = Len(Trim(Range("B2")))
   Set Tulis = Range("L5")
   ReDim D(1 To N) As String
   MaxRow = WorksheetFunction.Fact(N - 1)
   ActiveSheet.Unprotect xpas
   ClearDataArea ActiveSheet.Range("L2")

   If N > 9 Then
  MsgBox "max 9 digit, due to limitation on number of cells in a
sheet..", _
 16, ThisWorkbook.Name
  Exit Sub
   End If

   For k = 1 To N:  D(k) = Mid(Trim(Range("B2")), k, 1):  Next k

   Application.Calculation = xlCalculationManual

   Call ArrangeAndWrite(D, 1)
   Application.Calculation = xlCalculationAutomatic
   ActiveSheet.Protect xpas

End Sub



Private Sub ArrangeAndWrite(ByVal D, i As Byte)
   '  this is a recursive procedure
   '-
   Dim txt As String, tmp As String * 1, j As Byte
   *' limitation (if i = N)*
   If i = N Then
  For j = 1 To N: txt = txt & D(j): Next j
  If oRow = MaxRow Then
 oRow = 0: oCol = oCol + 1
  End If
  oRow = oRow + 1:  Tulis(oRow, oCol) = txt
   Else
  For j = i To N
 tmp = D(j): D(j) = D(i): D(i) = tmp
  ArrangeAndWrite D, (i + 1)
  Next j
   End If
End Sub
'---


you can download my example workbook, if you like, at:

http://www.box.net/shared/22pginzj8p

kind regards,
siti Vi



On Sat, Jul 2, 2011 at 10:47 PM, Markkim  wrote:

> Hi
> I can think of a way to write this macro.
> What I want is to find any possible combination of numbers from given
> numbers to a given total. For example,
>
> Let's say
> Given numbers: 1, 2, 3, 4, 5
> total = 30
>
> Will it be possible to get any combination of Given numbers adding up to
> 30?
> Macro should say number of possible combinations and details of
> combindation
> I have been thinking about this macro for long time...  but I can't think
> of any way..
>
> Any ideas???
> cheers!
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel