I have a mess in a workbook that was sent to me in a chopped up manner
and I was expected to put it back into something usable.
this is a massive excel sheet.At least to me
over 1 million lines of data.

I do databases not excel so this has been a learning exp.

I am cutting it in 256column X30 rows at a time and pasting into a new
sheet.

anyway I get 1004 errors after about 8 loops of this trying to cut and
paste this much data.
Someone said save during your work and this will help.

ok I forgot to ask how do I do a save like this in vba?

Application.ActiveWorkbook.Save()
didn't work. I am not sure how to do a save like this.

second thing the data now looks like this

COL B
10/26/2011
9:28
9:40

I need to find the date and copy it from its current B1 to A1
how do I look thru a column of data and find just dates?


thanks again for any help with this