Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA intro
Resolved · Medium Priority · Version 2007
Theodora has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
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/
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.CountWed 1 Jun 2011: Automatically marked as resolved.
|
|
Excel tip:Percentage formatCtrl+Shift+% applies the Percentage format, with no decimal places. |
TrustScore
4.8
/ 5
2188 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.06 secs.