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

F9 refresh

ResolvedVersion 2007

Mon 28 Nov 2011, 15:59 Delegate Richard said...

Richard has attended:
Excel VBA Intro Intermediate course

F9 refresh

Hi Anthony

Could you provide a vba code which you would recommend for using the advance filter

many thanks

Richard

Wed 30 Nov 2011, 23:45 Trainer Mark said...

RE: F9 refresh

Hello Richard,

It would depend on what you intend doing with the advanced filter, as there are numerous codes for applying this filter type. You may try looking at the following site for good code examples:
http://www.ozgrid.com/VBA/
or
http://www.excelforum.com/

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Wed 7 Dec 2011: Automatically marked as resolved.

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:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips

F9 refresh

F9 refresh

RE: F9 refresh

Excel articles

Excel tip:

Checking formulas with multiple operators