Select all full cells in column

[Lynx2x]

Hello there!


As you can see in a code below there is a range of all cells from column A. What must I change so that program will lookup only cells that are full...or in other words, not all cells in column A but only till last one is full.
Do you know what I mean?
Hope you can help me!

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[Lynx2x]

Ok, it does partly what I need. Some of the cells in column A are empty and if it is empty must skip it or lets say do nothig and it must start from row 2.
Thanks

[snb]

It does exactly what you asked for. Please analyse the code.

[Lynx2x]

Sorry, didn't mean to upset you.

It is like this. In column A there are phone numbers (starting in row 2 - row 1 is name of column). Now programe must lookup all of the records from column A and if certain criteria is met it copys the record to column B (phone), C (mobile), D(incorrect record). Now, some of the cells in column A are empty and if it is empty it must do nothing, just skip it.

Hope you know what I mean, thank you for your help and sorry if I said something wrong.