Hi,
I want to copy values only from one workbook to another and some cells being copied are merged. I would like to copy only values to another workbook but end up with a error.
I have used
[vba]
Dim wbSource as workbooks
Dim wbDestination as workbooks
wbSource.Worksheets("Sheetname").Usedrange.Copy wbDestination.Worksheets("SheetName").Range("A1").Paste xlPasteSpecial
[/vba]
Thanks