Hide Columns Based on Answer in an InputBox

Hi,

Is it possible to write a code that asks a user to input a column and it will hide the columns from that column to a fixed column?

For instance, if the fixed column is always 'AB' and in the InputBox the user put 'Z' in the field, it'll hide columns Z through AB.

And as a bonus : I want to prevent people from hiding columns that have data in it, is it possible for the box to return an error if the =sum(Z3:AB10)<>0?

Thanks so much!

Hi
try this macro

Please Login or Register  to view this content.

Originally Posted by NickyC

Hi
try this macro

Please Login or Register  to view this content.

Thanks --

Z was just an example and wouldn't be in the actual code, in the example, Z = whatever the user responded with
But I think i can play around w/ your code a bit and arrive at what I'm looking for
Thanks again

Hi
I included Z because you mentioned it, but you should be able to input any column letter in the inputbox and the macro should work hiding the range between that column and AB