how to change criteria Range become variabel in advanceFilter

[venol]

Excusme, I have problem with advanced filter to select data for 3 or more criteria. Generally the code use like this

Please Login or Register  to view this content.

But, How I can replace value CriteriaRange with my variable not use range like that. Because I use function to get result for criteria necessary but it's not work..

So, within Cell K5 i'm write "=getAllData("MERAPI", "66", "living room", "2010") and code below is the function..

Please Login or Register  to view this content.

And the problem is "Range("A2").VALUE = " not contain "MERAPI"



Thanks for your help..

[romperstomper]

You cannot do that with a function in a cell, since they are not allowed to change other cells.

Please note that I have altered your quote to code tags - please use those when posting code in future.

[venol]

Oh, I'm Sorry.. I forget if must placed tags code before place my code.

Thanks to remember..

======
Thanks romperstomper to your reply..

So, function can't do it to fill cell in worksheet like my code above ? Oh no, What must I do ? Do you have any idea for me please ?

[romperstomper]

You will have to use a subroutine.

[venol]

Thanks for your reply. I have use sub procedure with function too, But still not works..

wheter can't use function call sub routine to fill the cell ?

[venol]

Thanks for your reply. I have use sub procedure with function too, But still not works..

wheter can't use function call sub routine to fill the cell ?

[romperstomper]

No you can't. You cannot do it from a function in a cell - only a sub (no matter whether you call the sub from the function)