Macro Help

[michael_allen_24]

Hello,

I was wondering if any could point me in the right direction. I have a Macro that I have been using for a while that when I run it, it looks through my auto filter and pulls back the corresponding values. I have always used names in this formula. I am now trying to pull back numbers such as 10734624. When I adjust the AutoFilter field and run the macro with the numbers, it doesn't pull anything back. Why is that? Thanks.

Formula I am using for my Macro:

Range("E6:AE2496").AutoFilter Field:=2, Criteria1:=Application.Transpose(Range("C7:C66").Value), Operator:=xlFilterValues</SPAN>

 

[JLGWhiz]

Hello,

I was wondering if any could point me in the right direction. I have a Macro that I have been using for a while that when I run it, it looks through my auto filter and pulls back the corresponding values. I have always used names in this formula. I am now trying to pull back numbers such as 10734624. When I adjust the AutoFilter field and run the macro with the numbers, it doesn't pull anything back. Why is that? Thanks.

Formula I am using for my Macro:

Range("E6:AE2496").AutoFilter Field:=2, Criteria1:=Application.Transpose(Range("C7:C66").Value), Operator:=xlFilterValues</SPAN>

It probably doesn't know what to do with the array you created for Criteria1. I don't know that it will allow more than a single value to be used for Criteria.

 

[michael_allen_24]

Thanks for the response. It does work when I have multiple vales with names in there. Just not numbers.

 

[JLGWhiz]

Something I didn't know! The help file specifically says Criteria as a string, then show "101" as an example. But it would probably throw an error if you tried to use CStr like CStr(Application.Transpose(Range("C7:C66").Value). Maybe you could format the column or range as text.