focus on first empty row

[mabughazza]

hi all ..

I have a command button , so when click it the focus goes to the first empty row in the worksheet ..
this is my code ..

Please Login or Register  to view this content.

the problem is that this code take me to the first empty row after last filled "A" coluumn

example

- A B C D E F
1 5 4 5 5 - -
2 8 4 - 6 5 4
3 - 6 4 - 6 9
4
5
6

in this example .. MY CODE FOCUS on ROW 3 , BUT I WANT IT TO FOCUS ON 4 BECAUSE THIS IS THE FIRST EMpTY ROW ..

PLEASE HELP

[AndyLitch]

Use an alternative column to calculate the last row location .. Column B for example .

Please Login or Register  to view this content.

[mabughazza]

no .. the table is not fixed ..

this is a sample table ..

[rollis13]

If your table is the only data on that sheet try working on "UsedRange" with something like this:

Please Login or Register  to view this content.

[mabughazza]

unfortunately rollis13..

same result ..

[mabughazza]

FOUND THE SOLUTION ..

Please Login or Register  to view this content.

THANKS FOR ALL BTW

[rollis13]

unfortunately rollis13..
same result ..

Your example table does not match your true data. In your true data you have blank rows on the top.
All you had to do was add the number of blank rows to the count in the script.

Anyway, your solution is a working solution without bothering about blank rows.