relative value in macro
 

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

relative value in macro
 

For i = 1 To Cells(Rows.Count,"I").End(xlUp).Row
If Cells(i,"I").Value = "" Then
Cells(i,"A").Value = Cells(i,"C").Value
End If
Next i

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Janett" wrote in message
...
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

relative value in macro
 

Thanks a lot.

"Janett" wrote:

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