I have recorded a macro, using the mouse, as folows:


Sheets("rep90").Select
Columns("GN:GU").Select
Selection.Copy
Sheets("rep91").Select
Columns("GN:GN").Select
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

When I try to run the macro it gives an error message, highlighting columns,
to the effect that there are too many arguments on the second line of the
program. I am bemused as Excel itself wrote the procedure.

Thanks for any help

Dave Glynn

I copied the code out of your post and it ran perfectly. The problem is not
in the code, but probably in the cells.


Make sure there are no merged cells in either the source or destination range.
--
Gary's Student


"dave glynn" wrote:

I have recorded a macro, using the mouse, as folows:


Sheets("rep90").Select
Columns("GN:GU").Select
Selection.Copy
Sheets("rep91").Select
Columns("GN:GN").Select
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

When I try to run the macro it gives an error message, highlighting columns,
to the effect that there are too many arguments on the second line of the
program. I am bemused as Excel itself wrote the procedure.

Thanks for any help

Dave Glynn