Vba 사전 차이

2 차 AAA 레벨

나는 길고, N 은 길고, M 은 길다

최대값을 단일 값 Ar, Br 로 조정합니다

열 (I:M). 내용을 지우다

Ar = range ("a2: f" [a65536]. 끝내기 (3). 행)

Br = range ("G2: M6")

I = 1 하한 (Ar) 의 경우

사례 Ar(I 선택 (I, 1)

사례 Br( 1, 1) 에서 Br( 1, 2) 까지

N = 1

사례 Br(2, 1) 에서 br (2,2) 까지

N = 2

사례 Br(3, 1) 에서 br (3,2) 까지

N = 3

사례 Br(4, 1) 에서 br (4,2) 까지

N = 4

사례 Br(5, 1) 에서 br (5,2) 까지

N = 5

기타 상황

N = 0

선택을 마치다

N<& gt 이면 0 입니다

Br(N, 3)= Ar(I, 2)+Br(N, 3)

Br(N, 4)= Ar(I, 3)+Br(N, 4)

Br(N, 5)= Ar(I, 4)+Br(N, 5)

Br(N, 6)= Ar(I, 5)+Br(N, 6)

Br(N, 7)= Ar(I, 6)+Br(N, 7)

만약 ... 끝날거야

그리고 나서

For I = 1 ~ 5

최대값 = 0

N = 3 ~ 7 인 경우

If Br(I, n) "max 다음 Max = Br(I, n)

그리고 나서

Br(I, 3) = 최대

그리고 나서

Range ("G2: i6") = br

끝단 접합

아래 이것을 사용하지 마세요.

2 차 AAA 레벨

& amp nbsp & amp nbsp & amp nbsp & amp nbsp 나는 길고, n 길이, m 길이

& amp nbsp & amp nbsp & amp nbsp & amp nbsp 최대 값을 단일 값 Ar, Br 로 조정합니다

& amp nbsp & amp nbsp & amp nbsp & amp nbsp 열 ("I"). 내용을 지우다

& ampnbsp & ampnbsp & ampnbsp & ampnbspar = range ("a2: f" amp [a65536]. 끝내기 (3). 행)

& ampnbsp & ampnbsp & ampnbsp & ampnbspbr = range ("G2: M6")

& amp nbsp & amp nbsp & amp nbsp & ampnbspn =1

& amp nbsp & amp nbsp & amp nbsp & amp nbsp I = 1 하한 (Ar)

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp 선택 사례 Ar(I, 1

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp 종료 선택

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp N & amplt；; & ampgt；; 그럼 0

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp 가 ... 인 경우 종료됩니다

& amp nbsp & amp nbsp & amp nbsp & amp nbsp

& amp nbsp & amp nbsp & amp nbsp & ampnbspfor I =1~ 5

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp 최대 = 0

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp N = 3 ~ 7

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp Gt; 최대 다음 Max = br (I, n)

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp

& amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & amp nbsp & ampnbspbr (I, 3)= Max

& amp nbsp & amp nbsp & amp nbsp & amp nbsp

& ampnbsp & ampnbsp & ampnbsp & ampnbsprange ("G2: i6") = br

끝단 접합