98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access VBA Training and help » Steps in vba
Steps in vba
Resolved · Medium Priority · Version 2007
Aquila has attended:
Excel VBA Intro Intermediate course
Steps in vba
Hi
I want a macro to copy steps of rows eg, every 5th row. How would I write this?
RE: steps in vba
Hi Aquila, thanks for your query. Set up a loop down through your data (i.e. something like For NumRows = 1 To ....CurrentRegion.Rows.Count) and put "Step 5" at the end. Then within the loop put your copying code. That code will then only apply to every 5th row.
Hope this helps, let me know how you get on.
Anthony
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Switchboard StartupAn option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed. |