How do I loop in EXCEL !! Pls EX-cel-erate me!!

[bones288]

1.Have to compare contents of 2 cells.

 

[Martin Fishlock]

Bones,

Your request is a little vague. But there are four ways to loop in VBA:

1. IF THEN GOTO
i=0
aloopback:
i=i+1
IF range("A"&i) = range("B&i) then goto Aloopback


2. WHILE LOOP

i=1
while (range("A"&i) = range("B&i) )
i=i+1
wend

3. DO LOOP
i=0
do
i=i+1
while (range("A"&i) <> range("B&i) )

4. FOR

found=false
for i=1 to 1000
IF range("A"&i) = range("B&i) then
found = true
endif
nexi i
if found=true then
' do what you want to do
endif