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

help with loop code

From	eltyar <eltyar.130f09d8@excelbanter.com>
Newsgroups	microsoft.public.excel.programming
Subject	help with loop code
Date	2017-03-15 14:24 +0000
Message-ID	<eltyar.130f09d8@excelbanter.com> (permalink)
Organization	ExcelBanter.com

Show all headers | 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