Groups > microsoft.public.excel.programming > #109917

help with loop code

Path	csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail
NNTP-Posting-Date	Wed, 15 Mar 2017 09:49:02 -0500
From	eltyar <eltyar.130f09d8@excelbanter.com>
Newsgroups	microsoft.public.excel.programming
Subject	help with loop code
Date	Wed, 15 Mar 2017 14:24:06 +0000
Message-ID	<eltyar.130f09d8@excelbanter.com> (permalink)
Organization	ExcelBanter.com
User-Agent
X-Newsreader
X-Originating-IP
Lines	15
X-Usenet-Provider	http://www.giganews.com
X-Trace	sv3-zANokrOWdi77AAONhJwzj1A5H3aglee3U86/8NNy3esQrg1diJjfu/NDKqmzF/PTGkg+nFYMi19L6UZ!FFPIa54Aswbr4kyKLQAzWf3XZ0gPGCTcxxCF8FO530YbxEItfy9r0QloKWvvLb8HvYO823bFVaPR!yFUPRWo=
X-Complaints-To	abuse@newsgroupbanter.com
X-Abuse-and-DMCA-Info	Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info	Otherwise we will be unable to process your complaint properly
X-Postfilter	1.3.40
X-Original-Lines	7
X-Original-Bytes	1214
Xref	csiph.com microsoft.public.excel.programming:109917

Show key headers only | View raw

please how can i say in this code... do it when you see "ok" in cells of
column "P" and if any empty cells ignore it and continue?

this is the Code:

I = I + 1
Cells(1, "J").Value = "Outlook sent Time,Dynamic msg preview  count  ="
& I - 3
Loop While Cells(I, "P").Value = "ok"




-- 
eltyar

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

help with loop code eltyar <eltyar.130f09d8@excelbanter.com> - 2017-03-15 14:24 +0000
  Re: help with loop code Claus Busch <claus_busch@t-online.de> - 2017-03-15 16:05 +0100
    Re: help with loop code eltyar <eltyar.130fead8@excelbanter.com> - 2017-03-16 06:43 +0000

csiph-web