PDA

View Full Version : Paste Special?



alivenwell
09-27-2007, 03:33 AM
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:


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


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

Thanks

rory
09-27-2007, 04:33 AM
Try this:


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

alivenwell
09-27-2007, 05:25 AM
Works Thanks!