The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA Excel Report

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA Excel Report

Resolved · Low Priority · Version 2003

ReplyFri 11 Dec 2009, 13:03Delegate Sofie said...

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

For upcoming training course dates see: Pricing & availability

ReplySun 13 Dec 2009, 09:41Trainer Anthony said...

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

ReplyMon 14 Dec 2009, 16:26Delegate Sofie said...

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

ReplyWed 30 Dec 2009, 09:59Trainer Anthony said...

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

Tue 5 Jan 2010: Automatically marked as resolved.

Excel articles

· Do You Need To Upgrade From Excel 2003 to Excel 2007?
· How To Link Between Spreadsheets In Excel
· Don't Get Lost In A Sea Of Data, Use Excel Navigation
· Basic Excel Training
· How To Use Filtering In Excel 2010

Please browse our web site to find out more about
excel training seminar and other Microsoft training courses.

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips

Can you send me the advanced access 2007 timetable please

thanks

James