| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help with a Macro
How do i get it to due the following
IF L62 = 0 Hide Rows 63:147 IF L62 = 1 Unhide Rows 63:69 IF L62 = 2 Unhide Rows 63:75 If L62 = 3 Unhide Rows 63:81 If L62 = 4 Unhide Rows 63:87 If L62 = 5 Unhide Rows 63:93 If L62 = 6 Unhide Rows 63:99 If L62 = 7 Unhide Rows 63:105 If L62 = 8 Unhide Rows 63:111 If L62 = 9 Unhide Rows 63:117 If L62 = 10 Unhide Rows 63:123 If L62 = 11 Unhide Rows 63:129 If L62 = 12 Unhide Rows 63:135 If L62 = 13 Unhide Rows 63:141 If L62 = 14 Unhide Rows 63:147 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Help with a Macro
see yr post in other NG
Użytkownik "Leiprecht" napisał w wiadomo¶ci ... How do i get it to due the following IF L62 = 0 Hide Rows 63:147 IF L62 = 1 Unhide Rows 63:69 IF L62 = 2 Unhide Rows 63:75 If L62 = 3 Unhide Rows 63:81 If L62 = 4 Unhide Rows 63:87 If L62 = 5 Unhide Rows 63:93 If L62 = 6 Unhide Rows 63:99 If L62 = 7 Unhide Rows 63:105 If L62 = 8 Unhide Rows 63:111 If L62 = 9 Unhide Rows 63:117 If L62 = 10 Unhide Rows 63:123 If L62 = 11 Unhide Rows 63:129 If L62 = 12 Unhide Rows 63:135 If L62 = 13 Unhide Rows 63:141 If L62 = 14 Unhide Rows 63:147 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Help with a Macro
Hi
Look at this: Select Case Range("L62").Value Case Is = 0 Rows("63:147").Hidden = True Case Is = 1 Rows("63:69").Hidden = False Case Is = 2 Rows("63:75").Hidden = False Case Is = 3 'etc... End Select Regards, Per "Leiprecht" skrev i meddelelsen ... How do i get it to due the following IF L62 = 0 Hide Rows 63:147 IF L62 = 1 Unhide Rows 63:69 IF L62 = 2 Unhide Rows 63:75 If L62 = 3 Unhide Rows 63:81 If L62 = 4 Unhide Rows 63:87 If L62 = 5 Unhide Rows 63:93 If L62 = 6 Unhide Rows 63:99 If L62 = 7 Unhide Rows 63:105 If L62 = 8 Unhide Rows 63:111 If L62 = 9 Unhide Rows 63:117 If L62 = 10 Unhide Rows 63:123 If L62 = 11 Unhide Rows 63:129 If L62 = 12 Unhide Rows 63:135 If L62 = 13 Unhide Rows 63:141 If L62 = 14 Unhide Rows 63:147 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Help with a Macro
Sub HideUnhide()
If Range("L62").Value = 0 Then Rows("63:147").EntireRow.Hidden = True Else 'Rows("63:147").EntireRow.Hidden = True Rows("63:" & 63 + (Range("L62").Value * 6)).EntireRow.Hidden = False End If End Sub If this post helps click Yes --------------- Jacob Skaria "Leiprecht" wrote: How do i get it to due the following IF L62 = 0 Hide Rows 63:147 IF L62 = 1 Unhide Rows 63:69 IF L62 = 2 Unhide Rows 63:75 If L62 = 3 Unhide Rows 63:81 If L62 = 4 Unhide Rows 63:87 If L62 = 5 Unhide Rows 63:93 If L62 = 6 Unhide Rows 63:99 If L62 = 7 Unhide Rows 63:105 If L62 = 8 Unhide Rows 63:111 If L62 = 9 Unhide Rows 63:117 If L62 = 10 Unhide Rows 63:123 If L62 = 11 Unhide Rows 63:129 If L62 = 12 Unhide Rows 63:135 If L62 = 13 Unhide Rows 63:141 If L62 = 14 Unhide Rows 63:147 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
