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