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

1.Have to compare contents of 2 cells.

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

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

--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.


"bones288" wrote:


1.Have to compare contents of 2 cells.