Find the last cell with text in columns D till H and autofils.

This will select the last cell in column D with any data in it as long as there are no blank cells in the column until the end.

Please Login or Register  to view this content.

I could do a lot more if you gave me a sample of the workbook or worksheet you would work on.

thnx your code helped me to get a good start

and my workbook gets its data from other workbooks so if you try to test it and see an error it may probably be because of that.

the nš of lines that it copies from the dat files are the exact nš of lines it needs to do the autofill. i think a ".count" propertie should work. i'm tring it now bt to no avail.

so here you go the workbook: Book3_2.xls

***************************************************************

i edited the code now it selects the last cell and selects the next 4 columns.

Please Login or Register  to view this content.

now it just needs to autofill the exact nš of information it copied to sheet 1.

I've looked at the code, but as you stated I can't run it, nor can I get data.

Based on what I've seen, and the assumptions I've made, you need to create a variable that increments as the rows are counted in the loop that copies to Sheet 1, then you can use that variable to know how many rows should auto fill.

Also, the #N/A is not what text is in the cell. If you try to check it (i.e.- =IF(A1 = "#N/A") it will never come out true. You have to use the =ISERROR(A1) function to check for #N/A.