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"
wrote in message
...
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