PC Review


Reply
Thread Tools Rate Thread

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

 
 
ICSAnalyst
Guest
Posts: n/a
 
      15th Nov 2004

PLEASE HELP.. It may cost me my job!!!!


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

 
Reply With Quote
 
 
 
 
anilsolipuram
Guest
Posts: n/a
 
      15th Nov 2004

Sub Macro5()
'
' Macro5 Macro
' Macro recorded 11/15/2004 by RXVP
'

'
Dim t As Integer
Dim b As Boolean
b = True
While b
t = t + 1
If Range("a" & t).Value = "" Then
b = False
Else
If (Range("h" & t).Value = "0" And Range("i" & t).Value = "0"
Then
Rows(t & ":" & t).Select
Selection.Delete Shift:=xlUp
End If
End If
Wend
End Su

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving Current Row,Columns & copying Format from Row,Columns a Chris Maddogz Microsoft Excel Programming 2 28th May 2009 07:36 AM
Need to sum row 7 columns based row 8 columns that are not Blank Leew Microsoft Excel Worksheet Functions 3 27th May 2008 04:21 PM
How can I delete a row based on Columns H and I ICSAnalyst Microsoft Excel Programming 1 16th Nov 2004 11:19 AM
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below Annette Microsoft Excel Programming 2 21st Sep 2004 02:40 PM
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B Hannes Heckner Microsoft Excel Programming 1 5th Mar 2004 10:10 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:25 PM.