On Jan 22, 3:07*pm, CFS wrote:
Use a Worksheet event:

Private Sub Worksheet_Activate()
* * Range("A65536").End(xlUp).Offset(1, 0).Select
End Sub

--
CFS

"SangelNet" wrote:
Im trying to put together something that will set the focus on the
first blank cell of a range ("A") for each sheet.

the idea is that if i click on sheet1 the cursor will already be in
the first blank cell of column A. And if i click on sheets 2 and 3,
the same thing should happen.

Any ideas or links that tell me how to acomplish this?

Thnx

thank you it worked. had to change the xlup for xldown.

thnx again.