not sure what you mean in your first question, but if you have a range named
"test", this will select the first cell in the range:

range("test").Range("A1").Select

--


Gary

"art" wrote in message
...
Hello:

I have a userform with a refedit. I need to refer to the first cell (top) in
the rnage how can I refer to it?

Also How can I retrict the user to select only 1 column at a time, meaning
he can select a range from column C from row 1 to row 10000... but he cannot
also select C1 to D5?

Thanks