need help hiding unneeded rows and columns

[kennywai]

Hi all,

i need some help here trying to hide columns and rows that are not required by the user.


An input box will prompt the user for which columns and rows he would like to remain ( keep visible )
The macro will have to hide those that are not selected

My question is how to tell the macro which rows / columns ( non-contiguous ) are unneeded and how to write the syntax

Please Login or Register  to view this content.

[BigDat6CC]

Hello Kenny

Please try this as the basis for your macro:

Please Login or Register  to view this content.

I may not have covered all the errors that may occur if your user puts something silly in the Input Box.