I am unable to move down in excel cells by VB code

Hot Topic

Restrict editing of activity based on date comparison
OleDbConnection to Excel
Autofill
Adding a command button to the toolbar or menu bar in Excel?
macro in .xml
iexplore.exe - Application Error
Method 'OnAction' of object 'CommandBarButton' Failed
IIF Statement
How to stop a never ending loop
Once copied, can we export as a GIF file?

Microsoft ISV

VBA to VB/Java
How to connect two locations to better communication?
Simple thing: how to append to a jagged array?
beforeClose event bringing up compile error...
Problem: Macro not deleting columns I select
Excel function PRICE
excel formula
datagrid control in access
Text file search, return data from line other than search string line
"Bizzare" Sendkey Code in Excel

I am unable to move down in excel cells by VB code

I need to move by two cells down in excel by writing a code in visual basic by the click of a cammand button

Example: Now I am in cell A10 and I need to be moved by two cells down by pressing a cammand button. That is after clicking the cammand button My active cell should be cell A12.




Answer this question

I am unable to move down in excel cells by VB code

  • Squid Dog

    Thanks PSHK The codes given by you are perfect for my programme and I found it works the way I expected.

    Regards...

    Ajamilan



  • Yulia

    Try the following

    Sub X()
    Dim rngCurrent As Range
    Set rngCurrent = ActiveCell

    ActiveSheet.Cells(rngCurrent.Row + 2, rngCurrent.Column).Select

    End Sub



  • Arshu

    Sub Y()
    ActiveCell.Offset(2).Select
    End Sub

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______



  • I am unable to move down in excel cells by VB code
Answer this question