RangeEnd

[poiu]

Hello,

Please could you tell me why this code is getting the following error message (I've checked that there is data in cells A1 and A2):

"object doesn't support this property or method"

Set advanced_filter_criteria = Worksheets("Advanced filter").Range("A1").RangeEnd(xlDown)

Thanks,

Poiu

 

[lenze]

Maybe

Worksheets("Advanced filter").Range("A1").CurrentRegion

lenze

 

[poiu]

Thanks Lenze, now I am getting an error on the red line below:

"select method of range class failed"

Set advanced_filter_criteria = Worksheets("Advanced filter").Range("A1").CurrentRegion
[COLOR=red]advanced_filter_criteria.Select[/COLOR]

I definately have a worksheet called "Advanced filter" and data in cell A1, I can't think of what would cause the error?

Thanks,

Poiu

 

[poiu]

Hi, I found the solution:

I have to select the worksheet that the range is on first and then on the next line select the range.

thanks,

Poiu