# Posts by junho lee

Re: Calling A Subroutine

hi,
what is the red [COLOR="Red"]x[/COLOR] in the left text of add item buttons?

Re: Define Numerical Variables

hi,shg
regards,

hi,guys
i,d like to define variables,
a=2,7
i<j<k,m<n
5*a+10=i+j+k+m+n
i,j,k is defined in the process (i,j,k are three elements of a,a+1,a+2,a+3,a+4)
how do i define m,n.(two elements of a,a+1,a+2,a+3,a+4)
regards,

Re: Data Transfer

I made this just for fun.
ie. if 3 of 5 numbers make 10 or 20 then what is the other 2 number.

1.'make 10 or 20' is two. is not yet solve.
eg.(6,7,6,8,7) = ((6,6,8),7,7),((7,7,6),6,8) then choose first one.
same number has priority to not same 2 numbers.

2.in case (3,3,4,8,8),(2,2,6,7,7),(4,4,2,9,9).. also not yet solved.
eg. (3,3,4,8,8)=((3,3,4),8,8),((8,8,4),3,3) then choose first one.
big number has priority to small numbers.

regards,

p.s i used andy pope's code.

## Files

Re: Data Transfer

works fine. hi,
cells(a,b):cells(a+4,b) have 1,9,9,0,5
cells(a,b+3):clells(a+4,b+3) have 1,9,0,emtpy,empty.
how to fill 9,5 to empty cells.
always thanks !!

Re: Group Numbers By Sum Value

Sorry for this problem.
If ((6,6,8)7,7), ((7,6,7),6,8) both meets ,then choose ((6,6,8)7,7) i.e other two 7,7 is same.

Code
``For A = 2 To 7 Step 5``

I delete a=a+5.
Add 'step 5' to 'a=2 to 7' .
This is better then previous result.
Now how to insert other 2 numbers.
Many thanks.

Re: Group Numbers By Sum Value

nice to meet,Ger.
i noticed problems.
1.. 6,7,6,8,7 (6,6,8) and (7,6,7) make 20. case this residues big 7,i'd like rearrange lower row.
except this i noticed nothing.

I have 4sets of 5 numbers.
In each set if 3 numbers make 10 or 20 then i'd like to rearrange these to upper row.
But results are not like desired.
Regards, junho lee

## Files

Re: Did This Macro Delete Data In Column 'd' In Sheet 's2'?

Code
``````If Not MgDL(iZw, 1) < 1 Then
.Offset(0, 3 + MgDL(iZw, 1)).Value = MgDL(iZw, 2)
End If``````

I tested this then not deleted in column 'd'.

Re: Automatic Entry When Selecting A Cell

## Files

Re: Automatic Entry When Selecting A Cell

can't use worksheet change event?
select a1=x,select also a1="" etc.

Re: Run Except Particula Sheet

hi,Reafidy.
nice to meet you.