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

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

--
ICSAnalys
-----------------------------------------------------------------------
ICSAnalyst's Profile: http://www.excelforum.com/member.php...fo&userid=1509
View this thread: http://www.excelforum.com/showthread.php?threadid=27872

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

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.

ICSAnalyst wrote in message
...

::*Hi I would like to write an EASY macro on how to delete an entire row
if its column H and I both equal zero. Row 12 is my header row. the
macro needs to be looped until the A column has a blank cell. I am
having serious trouble. I tried looking at other macros to interepret
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*::


--
ICSAnalyst
------------------------------------------------------------------------
ICSAnalyst's Profile:
http://www.excelforum.com/member.php...o&userid=15095
View this thread: http://www.excelforum.com/showthread...hreadid=278729