Hi All,

I am using a macro which picks up a value from a sheet "Overview" goes to sheet "Input" and does an auto-filter in "Input" sheet. Then it picks up the filtered column and uses it further.

I have an issue with auto-filter when the value in "Overview" sheet is something like >= 200K amount . Excel Macro piks it up as a greater than filter, instead of being just a normal "equal to" with the filter on the provided value.

Code snippet:
Please Login or Register  to view this content.
I am just a beginner so if this question sounds basic, please forgive me

-Abhi