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 » VBA intro

	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

VBA intro

Resolved · Medium Priority · Version 2007

Reply Wed 18 May 2011, 15:44Delegate Theodora said...

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

VBA intro

on the course, we were given a formula to work out a calculation on a particular cell. How do I replicated this formula to work on all other cells/

For upcoming training course dates see: Pricing & availability

Reply Thu 26 May 2011, 10:28Trainer Stephen said...

RE: VBA intro

Hi Theodora

Thanks for your question

The easiest solution would be to simply copy down the formula down once you have inserted it into the cell

The following line of code should work OK

Range("A1").AutoFill Destination:=Range("A1").CurrentRegion.Rows.Count

Regards

Stephen

Wed 1 Jun 2011: Automatically marked as resolved.

Excel articles

· Create A Basic Timeline In Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Conditional Formatting: A Useful Feature Of Excel
· Advanced Excel Training - takes you to the next level
· Never Lose It In Translation With Excel

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

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips