Go to record end, then one across

[Munchkin]

I want my macro to select J7, go to the record end, then go across to the
next cell, which is empty. As you can see when I recorded my macro it
referenced a specific cell instead (K751). Hope I explained clearly - thanks
in advance for help.

Range("J7").Select
Selection.End(xlDown).Select
Range("K751").Select

 

[Bob Phillips]

Try

Range("J5").End(xlDown).Offset(0, 1).Select

 

[Jacob Skaria]

Try this

Range("J7").End(xlDown).Offset(1).Select

OR if you have blank cells in between try the below.....

Cells(Rows.Count, "J").End(xlUp).Offset(1).Select

 

[Rick Rothstein]

If I understand your question correctly, this should do what you want...

Cells(Range("J7").End(xlDown).Row, Columns.Count).End(xlToLeft).Offset(,
1).Select

 

[Rick Rothstein]

That code line should have all been on one line.

Cells(Range("J7").End(xlDown).Row, Columns.Count).End(xlToLeft).Offset(,
1).Select