Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Introduction/ interm VBA course London Bloomsbury

Introduction/ interm VBA course London Bloomsbury

ResolvedVersion 2007

Thu 7 Apr 2011, 14:26 Delegate Dorota said...

Dorota has attended:
Excel VBA Intro Intermediate course

Introduction/ interm VBA course London Bloomsbury

Is it possible to get the examples in Excel from the course.
Thanks,
Dorota

Mon 11 Apr 2011, 15:36 Trainer Stephen said...

RE: Introduction/ interm VBA course London Bloomsbury

Hi Dorota

Thanks for your question.

Just to confirm, are you seeking the completed file from the course with all the code included

Regards

Stephen

Tue 12 Apr 2011, 09:58 Delegate Dorota said...

RE: Introduction/ interm VBA course London Bloomsbury

That is correct.

W have been doing a different example during our course than the one that is available on the website to all attendants.

I had a training with Peter Murphy. The main example was about GP Rota. I know that we had access to Internet and I could have actually sent the example to my email box, but I thought we would be given it anyway.

Thanks,
Dorota

Wed 20 Apr 2011, 13:55 Trainer Simon said...

RE: Introduction/ interm VBA course London Bloomsbury

Hi Dorota,

Have you received the file?

If not can you please give me your email address and I will get Peter Murphy to send it to you.

Regards

Simon

Thu 21 Apr 2011, 12:23 Delegate Dorota said...

RE: Introduction/ interm VBA course London Bloomsbury

Dear Simon,
Thank you for your response. No, I have not received the file.
My email address: (email removed for privacy reasons)
Thank you and have a lovely Easter Holiday.
Best wishes,
Dorota

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Introduction/ interm VBA course London Bloomsbury

Introduction/ interm VBA course London Bloomsbury

RE: Introduction/ interm VBA course London Bloomsbury

RE: Introduction/ interm VBA course London Bloomsbury

RE: Introduction/ interm VBA course London Bloomsbury

RE: Introduction/ interm VBA course London Bloomsbury

Excel articles

Excel tip:

Sum Up All the Values in A Column