Move down 1 cell after going to the end of my data.
On Jan 4, 11:40 am, Pendelfin
wrote:
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
|