View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 74
Default 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