COPY WORKSHEET WITH VALUES IN CELLS BUT WITHOUT LINKS

Hi,

I want to copy worksheet in different workbook but i don't want to copy
links with this sheet (values only) , how i can make that?

Thanks

Mike

dim bk as workbook, bk1 as workbook
set bk = workbooks("destbook.xls")
set bk1 = workbooks("srcbook.xls")
bk1.worksheets(1).copy after:=bk.worksheets(bk.worksheets.count)
activesheet.cells.copy
activesheet.cells.pastespecial xlValues

--
Regards,
Tom Ogilvy

"michael sofianos" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I want to copy worksheet in different workbook but i don't want to
copy
> links with this sheet (values only) , how i can make that?
>
> Thanks
>
> Mike
>
>