VBA code for hiding column

I need help here with VBA.

I want to hide the row of player on the ATP Stats worksheet that have 0's in all competition, the file example can be download in next link.

http://www.excelforum.com/2033721-post1.html

Thanks.

I assume it's for the sheet named "ATP Stats"

Try

Please Login or Register  to view this content.

VBA Noob

heres an example of how to hide rows where a range of columns values are 0

Please Login or Register  to view this content.

Press Alt + F11 > insert module > paste in the code. Close VB editor > Press Alt + F8 > select HideZeros and run

VBA Noob

but the number seems to be not in order, can that be in an order (1,2,3,etc)?

Not what you asked. You would need to sort the data

Also how can I stop the module to run?

Don't understand the question

VBA Noob

Don't understand. Maybe a example

VBA Noob

Alright this is the problem, I already apply your code in my original excel and run the macro. After that the data in ATP stats worksheet don't have the number in order. This can be seen in the attachment file in this post, you can compare it with the original attachment from the first post. I just want after the module is run the number in worksheet ATP Stats in order.

Also after your module is applied anytime there is a row that is hidden have a point (1) it is not showed but still hidden.

Thanks.

This should help with changing data.

Code goes in sheet "ATP Stats". Right click sheet tab > select view code > paste in the below

Please Login or Register  to view this content.

VBA Noob

Before opening the workbook, do Tools > Macro > Security, and set to Medium.

Then open the workbook and enable macros when prompted.

Did you put the code in the worksheet.

Here's my example

VBA Noob

Thank you man that's what I mean for the add of players that just won tournament, but one more thing is as you can see that the number's in the left of players name is not in order. Anyway to fix that so it become in order?

Also if I want to use the code in other worksheet is there anything I have to change or I just copy it?

Thanks.

Will take a look after work but can you upload a example or the order you're after (Before and after sheet would be good)

VBA Noob

Seems to work. Code needs to go in "ThisWorkbook" Module and not the sheet module as before.

Added the other sheet names at this line

Please Login or Register  to view this content.

e.g

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

Yes. New code goes in ThisWorkbook module (see link)

http://www.contextures.com/xlvba01.html#Workbook

VBA Noob

Do I still need the previous code?

Thanks.

No.

As i said

Code needs to go in "ThisWorkbook" Module and not the sheet module as before.

By placing in Workbook module it will work on all sheets instead of activate sheet which you asked for

Please Login or Register  to view this content.

Then add the sheets names you want to run the code on as I suggested

PS. Best way to learn is to try so practice on a copy of the file first

VBA Noob

Yes, that should do it thanks again. But there is some error I see, first everytime I delete all the winner and finalist from ATP 2009 worksheet the excel goes ino a freeze in the previous code it's alright if I delete all winner and finalist it won't freeze. And when new data added to ATP Stats from Source (data after row 46), it don't get affected by the macro.

Second if the data that have been added is the last player in the list (Victor Hanescu) a number will appear outside the table in the ATP Stats worksheet. Can you look into that if you don't mind?

Also this is kinda stupid question, in the ATP Stats for a column that have 0 point is not visible right but when I copy it to other sheet the 0 appear and I forgot how I can make 0's not visible, can you help me into his also?

Thanks.

Sorry not going to go off course any more did more than your first post as for now

This help is free and we give it not to do you're project but for a specfic problem you have. At this rate I will be wasting so much time on this and not helping others

VBA Noob

Recording you're actions is a good way to learn and reading posts on the forum.

I would suggest Walkenbach's books.

If you want someone to finish the project and willing to pay you can post in the Commercial Services Exchange .


VBA Noob