software

I am a new user. I am tried to run a macro -- that does the following
if a column I is empty then Select the string in the column C and place in
the column A


For i = 1 To Cells(Rows.Count,quot;Iquot;).End(xlUp).Row
If Cells(i,quot;Iquot;).Value = quot;quot; Then
Cells(i,quot;Aquot;).Value = Cells(i,quot;Cquot;).Value
End If
Next i

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Janettquot; gt; wrote in message
...
gt; I am a new user. I am tried to run a macro -- that does the following
gt; if a column I is empty then Select the string in the column C and place
in
gt; the column A
Thanks a lot.

quot;Janettquot; wrote:

gt; I am a new user. I am tried to run a macro -- that does the following
gt; if a column I is empty then Select the string in the column C and place in
gt; the column A