Hide Rows and Update Chart based on cell value

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Hide Rows and Update Chart based on cell value

FAQ

Thread Tools

Display Modes

05-07-2012, 05:27 AM

Peter Wienand Peter Wienand is offline

Windows 7 64bit Hide Rows and Update Chart based on cell value

Office 2010 32bit

Novice

Join Date: May 2012

Posts: 15

Peter Wienand is on a distinguished road

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro based on cell value	ubns	Excel Programming	1	05-07-2012 04:03 AM
Calculating a cell value based on many variables	malawimick	Excel	0	12-14-2011 05:29 PM
How to highlight the row based on cell value?	Learner7	Excel	1	12-11-2011 02:28 AM
Temporarily show/hide selected table rows	glricht	Word Tables	0	12-29-2009 05:40 AM
Conditional Formatting to Hide Rows or Columns?	sczegus	Excel	0	09-26-2006 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 AM.