Thanks to both Frank and Peo for the answer.
In the old Lotus 1-2-3 you were able to hide a range "containing" columns by
using a macro such as
/ w c h r rangename~
which stood for worksheet-column-hide-range-" "
Oh well, you see what I'm saying anyway. Guess there has to be a law in the
office not to delete columns after I've programmed macros :)
"Peo Sjoblom" wrote:
You can only hide whole columns/rows. try to record a macro
while you hide the columns/rows that contain your range
Regards,
Peo Sjoblom
"Bill" wrote:
I need a Macro to Show / Hide a range called HIDEQUOTE.
The reason why I want to limit a Hide to a RANGE is if a column in the
middle were to be deleted, messing up any hope for Show/Hide column static
reference.
Thanks
|