How can I delete a row based on Columns H and I

  • Thread starter Thread starter ICSAnalyst
  • Start date Start date
I

ICSAnalyst

::*Hi I would like to write an EASY macro on how to delete an entire ro
if its column H and I both equal zero. Row 12 is my header row. th
macro needs to be looped until the A column has a blank cell. I a
having serious trouble. I tried looking at other macros to interepre
the logic, but i am having serious issues with the terminology in VBA
I know its easy..but I can't grasp.

I appreciate all help. Thanks*:
 
try this with small exstract of your data
this may not require macro

highlight whol data base including headers
clikc data-filter-autofilter
filter H column for 0
again filter I colum for 0
you will get only those rows having H and I zero
select these rows and cick edit-deleterows
now click data-filer -autofilter , that means autofilter is removed
do you get what you want.

on these steps create a macro.
 
Back
Top