iEnd = Range("J23").End(xlDown).Row
iEnd = Range("J65536").End(xlUp).Row

One or both of these should work. (You may need to change the number
depending on what cells in your sheet are used.) Then use iEnd in
code, e.g. like this:
Range("J23:J" & iEnd)

Hth,
Merjet