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 » Moving one cell down in VBA
Moving one cell down in VBA
Resolved · Medium Priority · Version 2007
Thu 11 Feb 2010, 17:57Delegate Sergio said...
Sergio has attended:
Excel VBA Intro Intermediate course
Moving one cell down in VBA
Hi,
I am trying how to express in VBA to move with cursor one cell down.
I use the following
"Selection.End(xlDown).Select"
to go to the last non empty cell but after that I would need to go one further cell down to do a paste.....however when I record the
macro I have got the following:
Range("A4").Select
Which obviously will move the cursor to the cell A4.....so is there a way to dynamically move the cursor one cell down?
Thanks a lot for the reply
Sergio
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:Entering text in Multiple WorksheetsIf you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows: |
