U urvashi1 New Member May 6, 2015 #1 How to move cell down if the above cell is filled with data using vba.
Faseeh Excel Ninja May 6, 2015 #2 You mean when you enter a data into a cell and press enter, it should move down to a lower row?
S Simayan Member May 6, 2015 #4 Hi, You can do it two ways Option 1 Dim I as Integer i = .Cells(.Rows.Count, "A").End(xlUp).Row + 1 Option 2 Dim emptyRow As Long 'Determine emptyRow emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
Hi, You can do it two ways Option 1 Dim I as Integer i = .Cells(.Rows.Count, "A").End(xlUp).Row + 1 Option 2 Dim emptyRow As Long 'Determine emptyRow emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
