Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
dave glynn
 
Posts: n/a
Default macros

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel crashes while opening excel file imbeddied with macros ct2147 Excel Discussion (Misc queries) 0 December 30th 05 09:05 PM
Protect macros? JulieD Excel Discussion (Misc queries) 6 August 25th 05 08:38 PM
Purge macros Don_S Excel Worksheet Functions 1 August 16th 05 03:51 PM
Enabling macros Peter M Excel Discussion (Misc queries) 3 February 7th 05 10:57 PM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 12:21 AM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"