2 more questions on excel and vba

[sparks]

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

 

[Jim Cone]

If the workbook has already been saved then... ActiveWorkbook.Save
It's in Excel's help file under "save".
(the newer excel help files are poorly done, so you get a mulligan <g>)
--
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
(a look at the Special Sort excel add-in (30 ways to sort)



"sparks" <[email protected]>
wrote in message
news[email protected]...

 

[Cimjet]

Jim,Not just the Help files that are poorly done today.
Nothing today is done the way it used to be.
Cimjet

 

[sparks]

Still have not come up with a way to find a date in a column of data.
I am trying to find a date in col B:# and copy it to col A:#
is there a way to find a date in a column of dates and times?

 

[sparks]

Ok I got it.
I was trying to find something like isdate or something.
I just looked for */* in the cell and it works