2 more questions on excel and vba

  • Thread starter Thread starter sparks
  • Start date Start date
S

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,Not just the Help files that are poorly done today.
Nothing today is done the way it used to be.
Cimjet
 
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?
 
Ok I got it.
I was trying to find something like isdate or something.
I just looked for */* in the cell and it works :)
 
Back
Top