hide row

Hi there, I am a total novice with VB and spent all yesterday reading through forums and help sites. (I promise to go buy a helpbook for dummies this weekend so I can skill up) But for my job this week I want to set up an automatic macro within a sheet called 'Q U O T E' that will evaluate...

:) Hi I need a macro to hide the entire row when all the cells of that row ="" also, the rows need to be able to unhide/rehide themselves when the data is updated. THANKS! :)

I'm very new to vba so I'm probably making hard work of this, but I've tried to write a macro that will hide certain rows based on the value of other cells. Good news is that when I play the macro it appears to work. Bad news is that I want to make the macro run every time the value of...

Hi, i have a slight problem.... i need a spreadsheet that hides rows depending on selections from drop down menus... i am quite new to using excel this way, and so far have only managed to solve a part of this problem. i have several headings, myob, name,photographer, viewer, spend....and a...

I have a spreadsheet with 188 rows. More specifically, 94 rows of 2. I want a check box in row1 to hide/unhide row2. By default, the box is unchecked and the row is hidden. When the box is checked, the row appears. Unchecking it makes it disappear again. I want to repeat this 94 times...

I have a worksheet containing 500 rows of potential data. Data validation list drop-down boxes are used to select assignments which are then referenced by Index & Match to automatically display in other parts of the worksheet as required. Up to 70% of the worksheet contains blank rows, waiting...

Hi there, I have a wee problem with hidden rows and hiding the option buttons contained in that row. I have several questions in a sheet which depending on the answer (yes or no) will unhide rows to ask more questions. All buttons are working OK (and have group frame around them) but...