Search results

Hi, is it possible to change the width of the dropdwon list box of a report filter in a pivot table? It is too short and the names are not displayed completely. I don't want the user to increase the width every time they need to select an item in the list. I hope someone can help me. Thank...

Hello, I need to change the Report Filter of a chart made on a pivot table just like explained here http://chandoo.org/wp/2011/04/27/update-report-filter-macro/ The only difference is that I need to allow multiple selection. Is it possible to do so? Do you have any suggestion? I can't...

Hello Luke, thanks! I have just done what you suggested. While debugging with F8 I have noticed that tha macro runs to the third line: Application.Run ("Report.xlsm!Delete_1") It runs the Delete_1 macro and than goes back to the first line: Sub test() It does not continue to the fourth...

Hi all! I have problems with reopening a workbook via vba. I need to run several macros on the same excel workbook. Each macro deletes cells in the original workbook. Just to clarify, the original workbook contains data of 8 different users and I use the macros to create 8 workbooks, one...

Hello Narayan, sorry for my late reply. Please accept my apologies. I was not in a position to respond to your post. Thank you very much for your help! It is helping me a lot! I am trying to do add a sort of FindNext feature to the macro you built becauses an item you are looking for can be...

Hi Narayan, I think I haven't write my question clearly so I'll try to explain it better. I'd like to run a sort of 'find' to search for a specific category name when you look at a chart. Imagine that you have a very long bar chart, with hundreds of category names, and you look for a...

Hi Narayan, is it easy for you to write the complete procedure? Or just giving hints on how to structure it? Thanks a lot! Vale

Hello, I have a bar chart with 400 (and even more) categories. Is it possible to look for a specific category name? I'd like a sort of 'find' function that searches through the categories names of the vertical axis and finds the category name you have typed. According to your knowledge, is...

Hello all, I've been working with Excel for one year to provide data analysis and dashboards to my Company's Management. I find the Chandoo web site and tutorials amazing. They've helped me so much and they are a great source for ideas and solutions. Thanks to you all! I hope to learn more...