Selecting range of visible cells

[poiu]

Hello,

The following bold line of code is giving the error message "select method of range class failed" (the range is made up of only visible cells). Please could you help?

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

Thanks,

Poiu

 

[RoryA]

If the FY2012 sheet is not active, you can't select the cells on it. You need to activate it first.

 

[VoG]

Try

Application.Goto input_data_range

 

[repairman615]

Hello

Try:
sheets("FY2012").Range("F8:X83")

 

[Weaver]

Just wondering why you'd want to 'select' the cells after you've defined a range - anything you'd do to a selection, such as copying, setting formats, adding text or a formula, you can do without selecting.

 

[poiu]

Just wondering why you'd want to 'select' the cells after you've defined a range - anything you'd do to a selection, such as copying, setting formats, adding text or a formula, you can do without selecting.

Hi Weaver, I'm testing the code line by line. I just want to see visually what I think excel has set to the range (I'm still trying to wean myself off that record button!)

Thanks

 

[poiu]

Try

Code:

Application.Goto input_data_range</PRE>

<!-- / message --><!-- sig -->__________________

Thanks VoG, worked a treat. Is it correct to say that the select method can't be used on ranges made up of lots of subranges?

 

[VoG]

No. As Rory said, to use Select you must Activate or Select the sheet first. That isn't necessary with Application.GoTo

 

[poiu]

Thank you VoG and Rory.