LOOPING STRUCTURE DESIRED 4 TWO RANGES

F

FARAZ QURESHI

I have two ranges as follows:
A1:A5 with values A, B, C, D, E (R1)
and
B1:B5 with values 1, 2, 3, 4, 5 (R2)

What kind of looping structure would lead to display:
A1
B2
C3
D4
E5
in message boxes? Following code displays unwanted entries like:
A1, A2, A3, A4, A5, B1, B2, B3, B4, B5, C1, C2, C3, C4, C5, D1, D2, D3, D4,
D5, E1, E2, E3, E4, E5
---
For Each MYC In R1
For Each MYC2 In R2
MsgBox MYC.Value & ", " & MYC2.Value
Next MYC2
Next MYC
---
How 2 overcome this problem???

Thanx in advance for all tyour expertise.

Best Regards
 
R

Roger Govier

Hi

Try

For Each MYC In R1
MsgBox MYC.Value & ", " & Offset(MYC,1,0).Value
Next MYC
 
F

FARAZ QURESHI

Thanx Roger,

But it was actually an example. The problem is that the ranges might be any.
Any way other than Offset???

Thanx again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top