how can I select a cell next to a cell in a row?

[dschmitt]

the code below shows how one can select a cell below a certain range in one column.

My question is:
How would the equivalent code look like if I want to select the cell next to a cell in a row?

Please Login or Register  to view this content.

[Paul]

Following the same principle - that you want to select the next column after the last used column in a row, try:

Please Login or Register  to view this content.

This refers to row 1.

[carsto]

I don't see that the question has anything to do with the example.

If you want to select the cell adjacent (to the right) of the active cell:

Please Login or Register  to view this content.

If you want to select the cell adjacent (to the left) of the active cell:

Please Login or Register  to view this content.

Or replace ActiveCell with any known Range, such as a variable or a name Range

Please Login or Register  to view this content.

Or, do you really want to select the cell next to the cell "below below a certain range in column"?
In which case you can complicate your exising code by adding offset, or change your variable to be the column not the row