I have figured out the code to the point that it does almost everything that I want, but I am missing how to unhide the rows when the balance in column M changes to a total other than zero. Here is what I have:
Please Login or Register to view this content.
Hey! I am very new to VBA so this might be wrong. But I dont understand "(Cells(i, "M"), Cells(i, "M"))", how can they both be same?? :OPlease Login or Register to view this content.
Last edited by NeedForExcel; 04-24-2013 at 11:57 AM.
Cheers!
Deep Dave
I don't think that I put it in the right location....
I am new to this code writting and I am still figuring out how it works. Thanks for your help!Please Login or Register to view this content.
Hi, har13y_d3v1l,
code goes behind the sheet:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Even I am new.And I am just trying to give you a solution.
However I dont think there was anything wrong in the 1st code except (Cells(i, "M"), Cells(i, "M"). I hope I am not wrong..
And u failed to mention Next i in the second code.Please Login or Register to view this content.
@msexcelathome,
is just a long way of sayingPlease Login or Register to view this content.orPlease Login or Register to view this content.Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks