range.activate

[Rune_Daub]

A simple question.
When i press s userform commandbutton, I want it to activate the firs
empty cell in the A collumn..
But how??

I can figure out as much as range(xxxxx).activate... But how do I ge
it to recognise the first empty cell?

I have thought of a countv(A:A)+1

But I cant get it to work properly..

Rune Dau

 

[Tom Ogilvy]

With worksheets("Sheet1")
.Activate
if isemtpy(.range("a1")) then
.range("a1").Activate
else
.cells(rows.count,1).End(xlup)(2).Activate
End if
End With