VBA - Delete all rows with zero value in particular column

[carlito2002wgn]

Hi,

I would like to be able to delete all rows of data which have 0.00 in the fifth column. The column header is "Hrs per Position", and the sheet name is "GPT to PlanView Mapping". The number of rows will change from time to time.

I found the following code, but it is not working for me, and I do not know how to fix it.

Option 1:

Please Login or Register  to view this content.

Option 2:

Please Login or Register  to view this content.

Any help would be greatly appreciated!!

Carlos

[sintek]

Hi Carlito

Welcome to the Forum.
In future please view the forum rules before posting. Your post does not comply with rule3.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window.

Please Login or Register  to view this content.

[carlito2002wgn]

Hi sintek, and thank you for the welcome message. Also, thank you for the code!

I am sorry that I did not follow all of the rules. Unfortunately, I do not even know what you mean by code tags.

Edit: I just figured it out. I'll use them in the future.

Ok, I am going to try your code now!

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)