Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Next without For..?
Hi,
I've written this bit of basic code to hide some rows for me: Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = "hiddenrow" Then Selection.EntireRow.Hidden = True Else Next i End Sub but when I try to run it it, it comes up with the Compile Error 'Next without For' I've used For & I can't see what I've done wrong! Can anyone help please? Thanks merry_fay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Next without For..?
Every IF statement would need a End If Statement which is missing in your
code.. Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = "hiddenrow" Then Selection.EntireRow.Hidden = True Else 'somthing End If Next i End Sub -- If this post helps click Yes --------------- Jacob Skaria "merry_fay" wrote: Hi, I've written this bit of basic code to hide some rows for me: Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = "hiddenrow" Then Selection.EntireRow.Hidden = True Else Next i End Sub but when I try to run it it, it comes up with the Compile Error 'Next without For' I've used For & I can't see what I've done wrong! Can anyone help please? Thanks merry_fay |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Next without For..?
insert "End If" instead of "Else"
On 29 Kwi, 12:28, merry_fay wrote: Hi, I've written this bit of basic code to hide some rows for me: Sub hiddenrow() * * Range("A1").Select * * For i = 1 To 516 * * ActiveCell.Offset(1, 0).Select * * If ActiveCell.Value = "hiddenrow" Then * * Selection.EntireRow.Hidden = True * * Else * * Next i End Sub but when I try to run it it, it comes up with the Compile Error 'Next without For' I've used For & I can't see what I've done wrong! Can anyone help please? Thanks merry_fay |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Next without For..?
Change Else to End if
"merry_fay" wrote: Hi, I've written this bit of basic code to hide some rows for me: Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = "hiddenrow" Then Selection.EntireRow.Hidden = True Else Next i End Sub but when I try to run it it, it comes up with the Compile Error 'Next without For' I've used For & I can't see what I've done wrong! Can anyone help please? Thanks merry_fay |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Next without For..?
Thankyou -I must have beeen having a really blond 5 mins!!
"Jacob Skaria" wrote: Every IF statement would need a End If Statement which is missing in your code.. Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = "hiddenrow" Then Selection.EntireRow.Hidden = True Else 'somthing End If Next i End Sub -- If this post helps click Yes --------------- Jacob Skaria "merry_fay" wrote: Hi, I've written this bit of basic code to hide some rows for me: Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = "hiddenrow" Then Selection.EntireRow.Hidden = True Else Next i End Sub but when I try to run it it, it comes up with the Compile Error 'Next without For' I've used For & I can't see what I've done wrong! Can anyone help please? Thanks merry_fay |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Next without For..?
merry_fay wrote:
Thankyou -I must have beeen having a really blond 5 mins!! "Jacob Skaria" wrote: Every IF statement would need a End If Statement which is missing in your code.. Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = "hiddenrow" Then Selection.EntireRow.Hidden = True Else 'somthing End If Next i End Sub -- If this post helps click Yes --------------- Jacob Skaria "merry_fay" wrote: Hi, I've written this bit of basic code to hide some rows for me: Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = "hiddenrow" Then Selection.EntireRow.Hidden = True Else Next i End Sub but when I try to run it it, it comes up with the Compile Error 'Next without For' I've used For & I can't see what I've done wrong! Can anyone help please? Thanks merry_fay Just an idea... Sub hiddenrow() Dim R As Long Const s As String = "hiddenrow" For R = 1 To 516 Rows(R).Hidden = Cells(R, 1).Value = s Next R End Sub HTH Dana DeLouis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|