I have to download a report from database, bring it into excel and the
format it to appear the way i want.
My problem is the macro i have recorded works but it always attahces i
self to a particular cell, for eg: in one down loaded report if i hav
"MN" in A10 and record the macro to delete this cell and in the nex
downloaded report "MN" is in A13, then the macro just goes and delete
A10 instead of A13.

I don't want to delete cell A10 but what i want the macro to find "MN
irrespective of cell and delete it.

Tell me how to record this. Hope you understand what i want. i ca
share a file if asked for

--
Message posted from http://www.ExcelForum.com

Record a macro to FIND "mn" in *entire cell*.

<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
"302001700 " wrote in message
...
I have to download a report from database, bring it into excel and then
format it to appear the way i want.
My problem is the macro i have recorded works but it always attahces it
self to a particular cell, for eg: in one down loaded report if i have
"MN" in A10 and record the macro to delete this cell and in the next
downloaded report "MN" is in A13, then the macro just goes and deletes
A10 instead of A13.

I don't want to delete cell A10 but what i want the macro to find "MN'
irrespective of cell and delete it.

Tell me how to record this. Hope you understand what i want. i can
share a file if asked for.


---
Message posted from http://www.ExcelForum.com/