Selecting visible cells for range

[poiu]

Hello,

The following code is giving the error message "object variable or with block variables not set".

input_data_range = Range("FY2012!F8:X83").SpecialCells(xlCellTypeVisible)

There are some hidden rows between rows 8 and 83 but I thought this would be taken care of by ".SpecialCells(xlCellTypeVisible)"?

Thanks,

Poiu

 

[VoG]

Try

Set input_data_range = Range("FY2012!F8:X83").SpecialCells(xlCellTypeVisible)

 

[poiu]

Thanks VoG!