Set TempCell : Object variable not set

[ltworf13]

The file run through and grabs my csf files but then stops when it get's to my left file. For some reason the Tempcell object variable get's lost and becomes nothing. When I step through the code I see that it hops backwarss back to close #1 then make TempCell = nothing. See attached

[ltworf13]

got it. The cell range I have to A1000 had to be formated for some reason for it to parse the data

[geekgirlau]

Don't you love it when the light bulb comes on and you fix the problem all by yourself? :rotlaugh:

Don't forget to mark this thread as "solved" using the Thread Tools at the top of the page.