If empty row msg error

[xam99]

Hello to all,
In the attached file, if a row is empty, it must give an error.
example:
now row 5 is empty
I write in row 6 must give error
Thanks you.
xam

[thebeastslayer]

Please Login or Register  to view this content.

Paste this code . You can change the column . I have assume COL A here. If ur row 5 is empty and you enter in row 6 it will give an msgbox that above row is empty.
Do you want to show error msg or restrict user from entering information ?

[thebeastslayer]

The below code will undo if u write in row 6 and will select 5 and display msg. Here is the code

Please Login or Register  to view this content.

[thebeastslayer]

Ur target range is A:L i suppose . The below code will find the first empty row in column and take you there . It will also undo ur entry. Cheers

Please Login or Register  to view this content.

[xam99]

Hi thebeastslayer thanks you.
I think it is exactly as I ask.
i have to try next week
A greeting
xam

[thebeastslayer]

Ok let me know if works.