macro to hide then show cells

  • Thread starter Thread starter aiqtadar
  • Start date Start date
aiqtadar

It may be easier to just hide & unhide the column with your answers. Goto
Tools>Macros>record new macro. Now Hide the column, (ie. column D) and stop
the recorder. Do the same thing to unhide the column. Now assign each macro
ro a button to either hide or undie you data.

Mike Rogers
 
You mention hiding A23:H28

You can only hide entire rows or columns, not ranges of cells within those rows
and columns.


Gord Dibben MS Excel MVP
 

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

formula inside a formula 4
formula help needed (if values) 2
Macro to hide sheets based upon cell value 3
Hide Unhide Buttons 3
macro showing and hiding detail 1
hiding cells then a button to show them again 1
After Macro runs, no cell activated - what am I missing? 2
Macro to hide rows with zero in specifc column range 2

Back
Top