Hi guys,
I have named ranges listed from columns A:H whos rows vary in size weekly.
These named ranges are defined by borders - start at A3, go down rows until bottom border is found - extend selection to column H and name range as the value found in the top left cell of that range.
offset 1 cell from the bottom border and set that as the top border for the next range then continue the same process until all ranges are found and named.
I want to create a macro that will toggle between hiding and showing named ranges.
The workbook is designed as a report viewer - which is to be embedded into IExplorer on an internal intranet site. Therefore there needs to have a fair bit of functionality and hence the reason why i need to be able to toggle the ranges.
I have a seperate worksheet "Data" that has a list of all the named ranges and the order they appear, in the column next to these named ranges is a 1 or 0 - which i want to use to define which ranges toggle what..
I.e. all those ranges that have a 1 next to them allows them to toggle any range below that have a 0 next to them until the next 1 is reached.
The Ranges with 0 cant be toggled.
Is this possible??
Regards
Bookmarks