PDA

View Full Version : Set TempCell : Object variable not set



ltworf13
08-21-2007, 02:29 PM
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
08-21-2007, 03:25 PM
got it. The cell range I have to A1000 had to be formated for some reason for it to parse the data

geekgirlau
08-21-2007, 05:32 PM
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.