I have a worksheet that uses columns a,b,c,d and e. (Range is a3:e4169)
If cell e3 = 0, then delete a3 through e3.
If cell e4 = 0, then delete a4 through e4..........and so on
I am not very good with Macro's, but will create one if need be.
However, if there is a conditional formatting that I could use, I would prefer to use that.
How do I go about creating a formula that will do the above?
Thank you very much for your help!
Guyel
Try this codeCopy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Ahhh, that is sweet!
Thanks for your help!!!
I have a similar issue where I need to delete the entire row if the value in column A = Dead End. I have tried using this macro but I am not very good with macros either.
If possble can you show me how the macro should look?
Try thisPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks