loop/ if statement needed

[Asche]

in the row 'A' is the only row I am working in at all.
I have code to copy something from a text.txt into the excel document.
but I need some code to have it check A1 to see if there is data in it. if so I want it to go to A2 check A3 and so on till it finds the first cell with no data in it.

 

[VoG]

Did I not answer this question here http://www.mrexcel.com/forum/showthread.php?t=326746

 

[Asche]

gave me an error. mite be the excel I am useing.
useing win2000.
and also that code starts from the last cell in the workbook. not from the top.

 

[Scott Huish]

You should continue in the original thread rather than start a new one.
Continuing in original post.

 

[Asche]

sorry. but this one is here now. I will make note of that for future reference.

 

[VoG]

Please post the exact code that you are using and indicate the error message and on which line the error occurred.

 

[Asche]

I completly redid the code but I will paste it back in and try again.

it sticks it in c column but I'll try to mess with it till it works

 

[Joe4]

Per forum rules, please do not start new threads on the same question. They will be locked.

Please continue on in the original thread.