Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Future queries.

	98.1 % recommend us
	More live stats...

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

Training information:

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

Future queries.

Resolved · Low Priority · Version 2003

Reply Thu 11 Jun 2009, 16:31Delegate Kanchan said...

Kanchan has attended:
Excel VBA Intro Intermediate course

Future queries.

Will i be able to get any guidance on particular databases related to my current job role in future?

For upcoming training course dates see: Pricing & availability

Reply Fri 12 Jun 2009, 15:00Trainer Amanda said...

RE: Future queries.

Hello Kachan

Thank you for your question and welcome to the forum.

You are welcome to post questions through relating to databases you are using at work, however it will depend on the amount of time that it would take to answer a post as to whether the forum would be an appropriate channel for us to provide assistance.

Kind regards
Amanda

Reply Tue 16 Jun 2009, 21:08Trainer Simon said...

RE: Future queries.

Hi Kanchan,

I have fixed the code and will send you the revised code in my next email.

In your mainMakeReport procedure you coded:

if blnPivot=true then call PivotAnalysis

It should have been:

if blnPivot=true then call PivotAnalysisMake

I also changed the name of the table in the MakeReport to Make Info.

Regards

Simon

Attached files...

Kanchan Dora Training file to be fixed for Make report.xls

Tue 23 Jun 2009: Automatically marked as resolved.

Excel articles

· Joseph And His Chart Of Many Colours
· How To Create A Custom List In Excel
· How To Create Formulas In Excel
· Improving Navigation Of Your Worksheets In Excel
· How To Link Between Spreadsheets In Excel

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

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips