Code works just the first time

[leyaclaire]

Hello,

I have the following code

Please Login or Register  to view this content.

I searches for the fist empty cell in row 3 and when it finds it puts a name saved in the variable "nume". The first time I hit the button works perfectly, but after that it doesn't do anything.

Any idea what's work? Thank you

[royUK]

It's an inefficient way to find the next empty cell in my opinion. I would ude

Please Login or Register  to view this content.

[sweep]

This works as described for me. Is it possible that the variable "nume" is reset elsewhere in your code?

[leyaclaire]

Hey again,

@royUK: Thank you for you answer! It works just fine for the first empty row in column 3, but I am looking for the first empty column in row 3 and I don't know how to modify it so it does what I want

@sweep: Thank you for you answer! I put a message box just before "Cells(3, x).Value = nume" and it shows me the right value for nume, so it isn't reset anywhere

[royUK]

Sorry I misread, just a slight amendment

Please Login or Register  to view this content.