Showing and hiding columns

  • Thread starter Thread starter Tom Ogilvy
  • Start date Start date
T

Tom Ogilvy

use the change event and check if the Target is cell C1. If so, then take
the appropriate action.
 
I need help hiding and showing columns based on a cell value. When my
workbook opens column H and I are hidden. Cell C1 is a cell that I have
validation. When the user selects "THIS" in cell C1 I would like column H to
appear. If the user selects "THAT" in cell C1 then I want column I to appear
and column H to be hidden. Can this be done?

T.I.A.

Ed
 
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

Array coding type mismatch 6
Hide Columns Based On Date Value 1
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
change cell value by code 6
hiding columns; dynamic 3
Change_Event troubles, no error & no work. 6
Hide column based on data validation 0
Event when cursor changes cells, but no select(?) 2

Back
Top