For Each error

[poiu]

Hello,

I'm trying to loop through each row of a range. The below code is causing an error on the 2nd line (in bold). The error message is "for each may only iterate over a collection object or array".

input_data_range = Range("FY2012!F8:W83")
[B]For Each input_data_range_row In input_data_range.Row[/B]
Next input_data_range_row

Please could someone help?

Thanks,

Poiu

 

[Trevor G]

What a bout something like this

Sub cop()
On Error Resume Next
Dim cell As Range, c As Long
For Each cell In Range("F8:W83")
'Your code goes here
Next cell
End Sub