Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear contents of a 3-d (three-dimensional) range
I can clear the contents of a range, but not a 3-d range. What's the
trick? I've tried assigning a name to the 3-d range, too - but that didn't work either. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear contents of a 3-d (three-dimensional) range
I'm not sure what a 3D range is. I understand what a 3D Name would be, but
that's not the same as a range. If you meant that the 3rd dimension was sheets, then maybe you could loop through the sheets and clear the 2 dimensional range on each sheet. On 08/27/2010 12:07, wrote: I can clear the contents of a range, but not a 3-d range. What's the trick? I've tried assigning a name to the 3-d range, too - but that didn't work either. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duplicate data in range clear contents | Excel Programming | |||
Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
Clear Contents of a Selected Range | Excel Programming | |||
Clear Contents Help | Excel Programming | |||
Dynamic Range Names & Clear Cell Contents Q | Excel Programming |