PasteSpecial in VBA

[RBI]

Attached is a template i am working on... there is a macro named macro4 which copies a specified range in the "Combos" sheet and pasteSpecials it in Sheet1. I used pasteSpecial for the skip blank feature so that it doesn't ovewrite other formulas. Can someone please open the file and run the macro while observing Sheet1 column "N". This column contains formulas and should not be effected by macro4 yet when macro4 is run cells in column N give a value of "" but the formula is still there ?? it's very strange i've never had a problem as such b4.. can anyone help..

Thank You

[Leith Ross]

Hello RBI,

Your code was attempting to reference a no existent object "Sheet". To return a Sheet object from the Sheets collection, you must use "Sheets" followed by the worksheet name. Here is the revised code..

Please Login or Register  to view this content.

Sincerely,
Leith Ross