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/
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.CountRegards
Stephen
