Help on Macro

  • Thread starter Thread starter 302001700
  • Start date Start date
3

302001700

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
 
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top