selecting the next empty cell in the column

[orit]

How suppose to be a macro that selects the next empty cell in column with few filled cells. or in other words, I have a sheet with few filled columns and few filled rows, and I want that the macro will select the first empty cell in the first column. how does such a macro go?

Thanks

 

[gnaga]

Try something like this

Range("A65536").End(xlUp).Offset(1, 0).Select

GNaga

 

[orit]

Thanks a lot, works perfect, can you please explain the code?

Thanks again