Cell Selection

[Guest]

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?

 

[Guest]

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

 

[Trevor Shuttleworth]

Chris

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

Regards

Trevor

 

[Guest]

Thanks.

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