Hi
you may post the code of your macro. As general idea: Consider defining
a name and using this name for referencing your range

--
Regards
Frank Kabel
Frankfurt, Germany

"Ali K" <Ali schrieb im Newsbeitrag
...
I have a large sheet which I need to be able to hide and unhide
sesctions
using macros. I would like my users to have the functionality to
amend the
size of these sections with out destroying the macros I have written
to
perform the hide/unhide functionality.

Does anyone have any suggestions that may help??