The macro recorder is not used for this type of operation.

First thing you do is make a backup of your workbook as it currently is
configured.

Then.......................................

Just copy the macro from my original post then paste into a general module.

To do that...............................

With your workbook open and after you have copied the sheet and pasted
special the values in column C.

Alt + F11 to open the Visual Basic Editor.

CTRL + r to open Project Explorer.

Select your workbook/project and right-clickInsertModule.

Paste the macro into that module.

Alt + q to return to Excel window.

With the copy of the sheet active, run the macro from ToolsMacroMacros.


Gord


On Tue, 3 Feb 2009 09:36:01 -0800, becky57
wrote:

Do I type this Macro exactly as you have typed it? I don't mean to sound
stupid...but I click on Record Macro and then type word for word, space for
space; or do I have to enter any cell info between the parenthesis? Thanks
for taking the time to answer my posting.