Try recording a macro when you do it manually and you'll have useable code.

Dim RngToCopy as range
dim DestCell as range

set rngtocopy = workbooks("book1.xls").worksheets("sheet999").rang e("x9:z15")
set destcell = workbooks("book2.xls").worksheets("sheet888").rang e("a1")

rngtocopy.copy
destcell.pastespecial paste:=xlpastevalues

application.cutcopymode = false

======
or just assign the value:
with rngtocopy
destcell.resize(.rows.count,.columns.count).value = .value
end with

Karen53 wrote:

Hi,

I thought I'd seen posts on this while looking for other information but now
I need them they are not coming up on any of my searches.

Can I copy cells from a sheet in one workbook into a sheet in another
workbook, but not as a link, the actual value?
--
Thanks for your help.
Karen53

--

Dave Peterson