I have a sheet . in A column i have cells with text , and empty cells .
I want the macro to search the column for given keyword . If found , to
go to next cell in A column . If that cell in empty , it should put "No
description" . If that cell is not empty , it should leave it as it is .
Example :

keyword : mother

A1: mother goes home
A2: house
A3: empty
A4: my mother is ...
A5: empty

So , A5 should become : "No description"

Thanks !


--
andrei
------------------------------------------------------------------------
andrei's Profile: http://www.thecodecage.com/forumz/member.php?u=1056
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=201969

http://www.thecodecage.com/forumz