No, I am trying to select the cell in Column one on any row of the
worksheet -- before launching (showing) a UserForm that is a
customized "Data, Form". I'm using the worksheet in its normal view,
and I want to launch the userform in order to be able to read/enter
data more easily using the UserForm. I get screwy error messages and
the UserForm.Show produces an error message on occasion. Selecting
the cell in Column A before launching the UserForm seems to fix
things.

Excel 2000.

Thanks,

Fred Holmes

On Tue, 14 Nov 2006 13:58:06 -0500, "Paul B"
wrote:

Fred, looks like you are selecting the cell below the last cell with data,
if that is the case try this

Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select