I created a spreadsheet with quarterly and annual data and grouped the
quarterly columns. I would like to create a macro to hide/show the detail of
the grouped columns so that I can display the annual data only or display
the quarterly and annual data together. When I tried to create a macro to
collapse the grouped columns ("hide detail"), I get the following error:
Run-time error '1004'
You've entered too many arguments for this function.
Here is the VBA printout:
Sub Quarterly()
'
' Quarterly Macro
' Macro recorded 2/11/2009 by Carrie Busch
'
' Keyboard Shortcut: Ctrl+q
'
Columns("D:AG").Select
ExecuteExcel4Macro "SHOW.DETAIL(2,33,FALSE,,27)"
ExecuteExcel4Macro "SHOW.DETAIL(2,27,FALSE,,21)"
ExecuteExcel4Macro "SHOW.DETAIL(2,21,FALSE,,15)"
ExecuteExcel4Macro "SHOW.DETAIL(2,15,FALSE,,9)"
ExecuteExcel4Macro "SHOW.DETAIL(2,9,FALSE,,3)"
End Sub
Any help would be greatly appreciated!
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
If you find any spam message in the group, please send an email to Ayush @
jainayus...@gmail.com
-~----------~----~----~----~------~----~------~--~---
