Paste Special?

[alivenwell]

I am copying a range of cells from one workbook, and pasting it into another. The cells are shaded grey, but I only want the values to pasted into the other workbook.

I've tried to do this:


[VBA]Workbooks(otherwb).Activate
Cells.Find(country).Select
Range("C" & ActiveCell.Row, "I" & ActiveCell.Row).Copy

sht1.Activate
Cells(x, colnum).Select
ActiveSheet.Pastespecial xlValues
Application.CutCopyMode = False
[/VBA]

But it deosn't work, can anyone help me?

Thanks

[rory]

Try this:
[VBA]

Workbooks(otherwb).Activate
Cells.Find(country).Select
Range("C" & ActiveCell.Row, "I" & ActiveCell.Row).Copy

sht1.Activate
Cells(x, colnum).Pastespecial xlPasteValues
Application.CutCopyMode = False

[/VBA]

[alivenwell]

Works Thanks!