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