Thread: Cell Selection
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Cell Selection

Thanks.

"Jim Thomlinson" wrote:

Using what you have here you would want to add the following line of code...
Selection.End(xlDown).Select
activecell.offset(1,0).select

or you could just modify the current line of code as follows:

Selection.End(xlDown).offset(1,0).Select

HTH



"Chris" wrote:

I am trying to add text after the last row that has data. I can get to the
last occupied cell with the command
Selection.End(xlDown).Select

How do I get to the next cell below?