How to Move the ActiveCell to the next row

[Murali1881]

Hi

Move the ActiveCell to the next row is simple:
ActiveCell.Offset(1,0).Select

Kindly help how to put the same inside the range instead of I6:

Range("I6").Select
Selection.ShowDetail = True


Thanks
Murali

 

[hiker95]

Murali1881,

If I understand you correctly, try the following:

With Range("I6")
  .Offset(1,0).Select
  Selection.ShowDetail = True
End With