View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Go to record end, then one across

Try

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

--

HTH

Bob

"Munchkin" wrote in message
...
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