Macro Code to Copy paste Special

Hi-

Instead of recording a macro, which produces a long string of items, is there a shortened code to copy one column and paste special values into another column. I want to do this for all my worksheets in my workbook. I would want to copy column F10:F32, and paste value speical into column G10:G32. Example of worksheet name = Corp Gov

Thanks

the cells f10:f32 are formulas. not sure if .copy range, copy's and paste value speical the cells?

i received error Run-Time error '1004' PasteSpecial method of Range Class failed

Please Login or Register  to view this content.

any ideas?

Thanks