| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mark the last three rows in a names range
Hi have a named range with 10 rows... I want to mark/hide the last 3 rows of this range depending on a cell value... anyone know how to do this? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=524754 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark the last three rows in a names range
Hi Ctech,
Go head with defining your condition and use : ActiveSheet.Rows("7:10").EntireRow.Hidden = True ActiveSheet.Rows("7:10").EntireRow.Hidden = False HTH Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark the last three rows in a names range
Id rather use:
Range("myname").rows("7:10").entirerow.hidden = True/False -- AP "Ctech" a écrit dans le message de ... Hi have a named range with 10 rows... I want to mark/hide the last 3 rows of this range depending on a cell value... anyone know how to do this? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=524754 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
mark the last three rows in a names range
set rng = range("Named")
if rng.rows.count 3 and rng.areas.count = 1 then rng.offset(rng.count-3,0).Resize(3).EntireRow.Hidden = True end if would be a generalized approach -- Regards, Tom Ogilvy "Ctech" wrote: Hi have a named range with 10 rows... I want to mark/hide the last 3 rows of this range depending on a cell value... anyone know how to do this? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=524754 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mark Rows for scrolling | New Users to Excel | |||
| using conditional formatting to mark repeated names in list? | Excel Discussion (Misc queries) | |||
| how do i mark range from A1 to DV5000 without scrolling? | Excel Discussion (Misc queries) | |||
| Mark a range from activecell | Excel Programming | |||
| Mark a range from activecell | Excel Programming | |||
![Ctech[_118_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
