# Posts by junho lee

• ## Calling A Subroutine

Re: Calling A Subroutine

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

• ## Define Numerical Variables

Re: Define Numerical Variables

hi,shg
regards,

• ## Define Numerical Variables

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,

• ## Data Transfer

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.

• ## Data Transfer

Re: Data Transfer

works fine.

• ## Data Transfer

Re: Data Transfer

here's some example.

• ## Data Transfer

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 !!

• ## Group Numbers By Sum Value

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.

• ## Group Numbers By Sum Value

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.

• ## Group Numbers By Sum Value

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

• ## Did This Macro Delete Data In Column 'd' In Sheet 's2'?

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'.

• ## Automatic Entry When Selecting A Cell

Re: Automatic Entry When Selecting A Cell

• ## Automatic Entry When Selecting A Cell

Re: Automatic Entry When Selecting A Cell

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

• ## Run Except Particular Sheet

Re: Run Except Particula Sheet

hi,Reafidy.
nice to meet you.

• ## Run Except Particular Sheet

is there a way to run procedure except particula sheets ?
eg. run all sheets except sheet4,5,6
regards,

• ## Sumif By Month

Re: Sumif By Month

Thank you for kind help ,Ger.

• ## Sumif By Month

Re: Sumif By Month

nice to meet you.

• ## Sumif By Month

Column A have random dates and column B have numbers.
How can sum numbers for each month By sumif function ?
Regards, Junho.