Macro for Show/Hide Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
AFAIK you can only hide rows and/or columns but not a rectangular range
 
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
 
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 :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to hide rows with zero in specifc column range 2
After Macro runs, no cell activated - what am I missing? 2
Hide Unhide Buttons 3
Macro to Hide columns 3
Macros - variable columns 1
Is there a quick way to show selected columns (not using hide) 4
Hide and Show Rows based on Cell Value 2
Another query about hiding columns with Macros 4

Back
Top