ActiveCell.Text

  • Thread starter Thread starter George
  • Start date Start date
G

George

I need a macro to delete any row in a spreadsheet that
contains a certain word. I know how to do this for a
number or formula, but how do I find a cell that contains
a specific word?
 
Could you not just just Find-Replace on the whole sheet (Ctrl A) and use
an empty string "" as the replace string?

Gromit
 
Just use the word as the search string (the "FindWhat:=" argument). It
should work just fine. If not, post the code that's not working as expected
and we'll take a swing at it. (Best is in .programming rather than this
newsgroup.)
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
 
Back
Top