Clear contents of a 3-d (three-dimensional) range

  • Thread starter Thread starter excel
  • Start date Start date
E

excel

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.
 
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.
 
Back
Top