tag:blogger.com,1999:blog-7603152763857688635.post5905319781300061883..comments2023-07-23T12:42:14.354+02:00Comments on Sparklines for Excel®: Another Treemap sample fileMes Courshttp://www.blogger.com/profile/09265743268811431064noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7603152763857688635.post-52653243147297034322010-01-02T17:38:23.678+01:002010-01-02T17:38:23.678+01:00Hi Alessandro.
I could not replicate your error.
...Hi Alessandro.<br />I could not replicate your error.<br /><br />I suggest you delete all names of named ranges w/ the Name Manager and delete all shapes on page then refresh sparklines. Shapes are not grouped because the code is interupted just before the grouping instruction... I keep searching !Mes Courshttps://www.blogger.com/profile/09265743268811431064noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-75144320876039631212010-01-02T01:51:36.124+01:002010-01-02T01:51:36.124+01:00Hi Fabrice! Once again you are very positively sur...Hi Fabrice! Once again you are very positively surprising us...<br />Well, I was just giving your last treemap example a try, and it´s not grouping the rectangles...don´t know why. Any tip?<br />Regards,<br /><br />'Named after the cell that contains the formula : Destination<br />With DestinationRange.Worksheet.Shapes.Range(Arr)<br /> .Group<br /> .Name = "Sprk" & Destination.Address(, , xlR1C1) & "Shape"<br /> Destination.Worksheet.Names.Add Name:="Sprk" & Destination.Address(, , xlR1C1), RefersToR1C1:="='" & Destination.Worksheet.Name & "'!" & Destination.Address(, , xlR1C1)<br />End WithAlessandrohttps://www.blogger.com/profile/17218242185578989323noreply@blogger.com