Sofie has attended:
Excel VBA Intro Intermediate course
VBA Excel Report
Hi,
How do I get VBA to produce a full list of names and cities so that if a user selects ALL, it will provide them with the full list rather than a subset when a specific city is selected?
Thanks,
S
RE: VBA Excel Report
Hi Sofie, thanks for your query. Can you tell me a little bit more about your source data and what you're trying to do with it? It sounds like your code is filtering data whereas you want to turn off that functionality. Any more information?
Anthony
RE: VBA Excel Report
I have 5 different categories and i can get it to run the report to select 10 specified columns and produce a report. However I cannot seem to find a way to get it to show all categories if I for example selected "All"?
Is there a way around this?
Thanks
RE: VBA Excel Report
Hi Sofie, thanks for your query. What code are you using to select the different categories? You should be able to use, say Range("A1"). CurrentRegion to select all the data and then loop through it for a complete report. It sounds like your source data structure and code are both contributing to the problem. Try creating a dummy spreadsheet with a more basic data structure and see if you can generate a full report from that. Let me know how you get on.
All the best,
Anthony
