macro to change row height based on criteria in row above

Thank you to anyone who helps me with this. I'm on a deadline. I'm amending a workbook someone else created and I'm brand new to VB. I've attached a screenshot to illustate what I am doing.

I've got a table that has over 200 rows and the users enter information into the rows over a year. The creator of the sheet has set it up so there is a "z" in the second cell of each row and as this cell is overtyped with the new information the row changes colour and is included in the print macro that is set up.

I want to add in a macro that changes the row height to 0 based on the "z" being present in the row above 2nd cell. So all that is showing in the table are the rows that have info in them and one blank one underneath. So everytime a new row of info is entered either a new line will reveal itself underneath or there is a control button on the sheet that the user can press to reveal a new empty line.

I don't know how to write VB, but I've found some code online that claims to do waht I need, but I need it to be altered to use the presence of the "z" in the row above (2nd column) as the trigger for the rule:

Please Login or Register  to view this content.

Or should I be starting off with minimised rows and changing it so the height increases as the "z" in the row above is overtyped?

The table is rows 12:217.

Can this happen automatically as the z is overtyped or does the macro need to be triggered by a control button for example?

Is there a better way to do this? I don't want to get rid of all the extra empty rows and have a macro to create a new row for 2 reasons: 1.They have formulas and macros running set up by the creator that I don't want to mess with and 2. There are 52 sheets in the workbook, 1 for each week of the year and the next sheet takes the information from the previous weeks sheet so on the last sheet, number 52, it has every line that has been entered over the year from week one to week 51 carried over. If I created a new row on week2, I would have to then create that row on every sheet following week 2 and I think that would make it more complicated.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Please post a copy of your book as most people will not try to duplicate a book from your picture

Axild

I suggest you read the details on cross posting before you post another the same question/problem on mutlipe forums

http://www.excelguru.ca/node/7