parscon
04-20-2013, 01:14 PM
I have a data on column A about 66000 row , Now i need a vba code that if find a matched data for example "apple" cleran the contect of that cloumn
For example :
A1: SomeDATA
A2: DATASOME
A3: apple
A4: DATA
When run the VBA:
A1: SomeDATA
A2: DATASOME
A3:
A4: DATA
A3 will be clean . and important thing i do not want delet the row just clean the column .
THank you
For example :
A1: SomeDATA
A2: DATASOME
A3: apple
A4: DATA
When run the VBA:
A1: SomeDATA
A2: DATASOME
A3:
A4: DATA
A3 will be clean . and important thing i do not want delet the row just clean the column .
THank you