Hi Sudhir,
Try this,,,
hope u r talking abut grouping and ungrouping
Rows("1:2").Select
Selection.Rows.Group
--- On Sat, 24/4/10, sudhir <sudhir.p...@gmail.com> wrote:
From: sudhir <sudhir.p...@gmail.com>
Subject: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide
the subheading in excel
To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
Date: Saturday, 24 April, 2010, 8:53 AM
Dear friends,
I want a macro for hide and unhide the sub headings in excel, like we
can do in MS project with +mark, when we click on + symbol it
highlights the subtask available in that particular task.
Is it possible??., pleas help me
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
