BlnPivot

Resolved · Urgent Priority · Version 2003

Fri 15 May 2009, 17:15 Delegate Sherine said...

Sherine has attended:
Excel VBA Intro Intermediate course
Excel Advanced course

BlnPivot

Simon please can you look at my code and maybe work out why it says blnPivot is ambiguous? It's saved to the desktop.

My email is:
sherine@coram.org.uk

Many thanks for everything!

Best,
Sherine.

Mon 18 May 2009, 13:41 Trainer Simon said...

RE: blnPivot

Hi Sherine,

Thank you for the question.

I will look at the code tonight as I am training today.

Regards

Simon

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

BlnPivot

BlnPivot

RE: blnPivot

Excel articles

Excel tip:

Sorting List Subtotals