Move down 1 cell after going to the end of my data.

[Guest]

Please can someone let me know what I should enter to move down to the next
cell in my macro,instead of it moving to a specific cell. I recorded the
following, but instead of going to cell A15 i want to go down to the next
cell.
Many Thanks in advance.

Selection.End(xlDown).Select
Range("A15").Select

 

[Mike Woodhouse]

Please can someone let me know what I should enter to move down to the next
cell in my macro,instead of it moving to a specific cell. I recorded the
following, but instead of going to cell A15 i want to go down to the next
cell.
Many Thanks in advance.

Selection.End(xlDown).Select
Range("A15").Select

Try Selection.Offset(1,0).Select

or more tersely

Selection.End(xlDown).Offset(1,0).Select

HTH,

Mike

 

[Mike Fogleman]

Selection.End(xlDown)(2, 1).Select

An Offset feature (2=nextrow,1=same column). (1, 1) would be no offset.

Mike F

 

[Tom Ogilvy]

If you are saying you want to copy the formula from B8 then

Selection.Offset(1,0).Select
activecell.offset(-1,0).copy activecell

possibly.