[RESOLVED] error when pasting to a new workbook

[scoobster]

All working fine now so thanks for the input.

Working code to copy the value of columns C to K onto cell A1 of the newly created workbook is as follows;

                rng.Columns("C:K").SpecialCells(xlCellTypeVisible).Copy
                shtDest.Range("A1").PasteSpecial xlPasteValues