Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Entire Row

Status
Not open for further replies.
komark

komark

Technical User
Sep 12, 2005
134
US
I need a macro in Excel that would check the value for a certain cell. If the value is zero then delete that entire row.
Can anyone help me please?
 
Sort by date Sort by votes
Have a look at the EntireRow property of the Range object:
If CertainCell.Value = 0 Then CertainCell.EntireRow.Delete

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
980
SkipVought
S
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
654
remeng
remeng
MattGreer
  • Locked
  • Question
Delete a Table Row in a Filtered Table 2
Replies
11
Views
1K
SkipVought
S
davefish
  • Locked
  • Question
Looping through a word doc to delete rows
Replies
7
Views
534
macropod
macropod
remeng
  • Locked
  • Question
Row count for table after filtering
Replies
8
Views
2K
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top