Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in grouping rows in excel using VB
Hi all-
Some code I used from a previous thread- this code allows a user to double click a row to ungroup or group it. Works great, until you double click a row that isn't grouped. I then get this error: "Unable to set the Showdetail property of the Range class". Anyone know of a way around this? Here is the code I'm using in Excel 2002. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean) Target.EntireRow.ShowDetail = Not Target.EntireRow.ShowDetail End Sub Thanks in advanced! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping Rows in Excel 2007 | Excel Discussion (Misc queries) | |||
Grouping Rows | Excel Worksheet Functions | |||
grouping error in Excel 2003/2007 Pivot table connect to offline c | Excel Worksheet Functions | |||
Error on grouping | Excel Discussion (Misc queries) | |||
Grouping Rows | Excel Discussion (Misc queries) |