advance to next cell in column

f0h

New Member
Joined
Nov 2, 2002
Messages
14
I am still not able to accomplish what I am attempting to do. Let me try again. Let's say my active cell is A1 and I want to advance to the next cell down (A2) as if I have hit the enter/return key. Regardless of what data is in the cell.
What would this code be?

DBL THANX
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
"...as if I have hit the enter/return key"

why not just hit it? please explain you problem in more detail.

paddy

(N.B. Note that if you have a previous post where this detail is, you should simply post a reply to that post, thereby 'bumping' it back to the top of the list. If this earlier "context setting" post exists, don't assume that people will look for it - you should at least post a link to it. If the post does not exist, the general message is that the better you describe the context of your problem, the more likely you are to get an answer, and the more likely that answer is going to solve your problem).
 
Upvote 0
I wrote a macro that copies a row of data from one sheet to another. The original question is so that I can repeat the macro and each time it advances to the next row down
 
Upvote 0
Sub Macro5()
'
' Macro5 Macro
' Macro recorded 11/3/2002
'

'
Windows("Project copy").Activate
Sheets("sheet5").Select
Columns("A:A").Select
Selection.Find(What:="1", After:=ActiveCell, LookIn:=xlValues, LookAt:= _xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False).Activate
ActiveCell.EntireRow.Select
Selection.Cut
Sheets("Sheet4").Select
ActiveSheet.Paste
ActiveCell.Select

End Sub

this code works fine i just need a way to get to the next cell down which is an empty line
 
Upvote 0

Forum statistics

Threads
1,213,524
Messages
6,114,117
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top