ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inserting lines that don't destroy macros (https://www.excelbanter.com/excel-programming/314880-inserting-lines-dont-destroy-macros.html)

Ali K

Inserting lines that don't destroy macros
 
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??

Frank Kabel

Inserting lines that don't destroy macros
 
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??




All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com