98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
VBA
Resolved · Low Priority · Version 2003
Tue 7 Oct 2008, 09:31Delegate Eivind said...
Eivind has attended:
Excel VBA Intro Intermediate course
VBA
How can I make excel (VB) paste the next cells that I have copied right below the previous cells I pasted?
Wed 21 Jan 2009, 15:54Trainer Laura said...
RE: VBA
Hi Eivind
Thank you for your question.
You can include the paste destination on a copy line
ActiveCell.Copy Destination:=ActiveCell.Offset(1, 0)
I hope that helps.
Laura GB
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. |
Excel tip:Shortcut for accessing recently opened filesTo get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu. |
