Microsoft Office Forums - View Single Post - [Solved] Hide Rows and Update Chart based on cell value

Thread: [Solved] Hide Rows and Update Chart based on cell value

View Single Post

Old

05-07-2012, 05:27 AM

Peter Wienand Peter Wienand is offline

Peter Wienand is offline

Peter Wienand uses Windows 7 64bit

Windows 7 64bit Peter Wienand uses Office 2010 32bit

Peter Wienand uses Office 2010 32bit

Office 2010 32bit

Novice

Join Date: May 2012

Posts: 15

Peter Wienand is on a distinguished road

Default

You will need to modify the code for your spreadsheet. In particular the line

retireAge = Sheets("Sheet1").Range("B3").Value

needs to be changed to point to the cell containing the retirement age and all other Sheets("Sheet1")'s should refer to the worksheet on which the rows are to be hidden.

Reply With Quote