Move to new active cell

[kemit]

Good Morning

I need to select the next empty cell in a column.

The instruction below goes to the last nonblank cell in the column. I now need it to move to the next cell so that I can then work with that cell.

Selection.End(xlDown).Select

What method can be used to move the cursor in a direction by a variable amount of cells?

[MarvinP]

Hi kemit and welcome to the forum,

I like to use code like:

Please Login or Register  to view this content.

Rows.Count is the bottom row of a sheet (it differs between older and newer Excel)
Search the net for xlUp, xlDown, xlToRight, xlToLeft to tell what direction to move.

The "End(xlUp)" command is like doing a Ctrl Up Arrow.

see http://msdn.microsoft.com/en-us/libr...ffice.11).aspx