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

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" <(E-Mail Removed)>
wrote in message
news(E-Mail Removed)...
>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,
>>>the newer excel help files are poorly done<<<
Not just the Help files that are poorly done today.
Nothing today is done the way it used to be.
Cimjet
"Jim Cone" <(E-Mail Removed)> wrote in message
news:j8a8dt$86p$(E-Mail Removed)...
> 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" <(E-Mail Removed)>
> wrote in message
> news(E-Mail Removed)...
>>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
>>
>
>

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?


On Wed, 26 Oct 2011 14:29:20 -0500, sparks <(E-Mail Removed)> wrote:

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

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



On Wed, 02 Nov 2011 11:37:54 -0500, sparks <(E-Mail Removed)> wrote:

>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?
>
>
>On Wed, 26 Oct 2011 14:29:20 -0500, sparks <(E-Mail Removed)> wrote:
>
>>COL B
>>10/26/2011
>>9:28
>>9:40