Sorry - When I say doesn't work I mean it comes up with error "Run-time
error '-2147352565 (8002000b)': The sheet you are copying has cells that
contain more than 255 characters. When you copy the entire sheet, only the
first 255 characters in each cell are copied.

To copy all of the character, copy the cells to a new sheet instead of
copying the entire sheet."

Having thought about it, maybe a bit of error handling would sort it out.
Not sure though...

"Andibevan" wrote in message
...
Hi All,
I am using the following code to copy a sheet two sheets to new workbooks
(seperate workbooks):-
sheets("Sheet1").copy
sheets("Sheet2").copy

This does not work as some of the cells contain more than 255 characters.

I want two copy sheet1 and sheet2 to two new workbooks respectively.

I then want to save each of them in the format Sheet_1_MONTH where MONTH
is
the month the file is saved in.

Any help or pointers would be helpful.

Thanks

Andi