hide cell

  1. S

    [VBA] If "yes", shows cell content

    Hi everyone, I'm new in VBA and have looked into this for a week but couldn't find any solution T___T I have defined a name to range J38:Q38 with name "Claim" with drop down list option of 'Yes' and 'No'. I would like to make this condition: If "Claim" = 'Yes', cell AK38 shows its content...
  2. C

    Use Options (forms) to Specify Specific Data Validation List

    Hello, Wanted to know if there is a way to use Options (form) button that changes the type of Data Validation List that appears? Also if there is a way to use the same option button to hide or show certain cells based on the options chosen? Example: User chooses A or B using Option (Forms)...
  3. C

    Formula/ macro help needed.

    Hey there guys, New to the forum and I really need some help. Heres my problem Im attaching screen shots to better aid you. *IF D5>2 C7 AND D7 SHOULD BE HIDDEN. * F6 is a drop down list with FR4,Polyimide G6 is a drop down list based on F6 I.E IF F6 is FR4 G6 would have options...
  4. H

    Need to copy column results while hiding empty cells

    I have a column(for example: b1:b5000) that has cells that have info, and many other cells in that column that are empty. I have copied that column to another worksheet. On the new worksheet, I need to leave the order of the cells with info in the same order, but remove all of the empty cells...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top