how to change criteria Range become variabel in advanceFilter

**venol** · 10-17-2011, 06:16 AM

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** · 10-17-2011, 06:20 AM

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** · 10-17-2011, 08:34 PM

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** · 10-18-2011, 02:31 AM

You will have to use a subroutine.

**venol** · 10-18-2011, 11:21 AM

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** · 10-18-2011, 11:35 AM

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 ?