Forum Discussion
Filter Function
I am not sure why the Filter Function is not working or calculating while i am using the VBA even though i have calculation is on the automatic. Once the marco is run, i change the Cell value filter function works.
3 Replies
- You can't do any excel work while the macro is running in background. It is based on what type of macro programme is running.
Logaraj Sekar The File in which I run the macro has the filter formula used in one of the tabs which help me to filter the data after Marco copy's the data and paste in the closed file in one of the data tab. The problem I am having is that that filter formula doesn't work and was working before but now i am not able to figure out why filter formula is not calculating.
There are several reasons for that.
- The macro may contain sheet name, after copying the code it won't work. Eg. If they wrote for sheet name "Summary", the macro would run only in the sheets named with "summary", not in "Sheet1", "Sheet2". This will also be applicable for file name, etc.
- Whether the data is there for filtering, copying, etc.
- While copying macro from a Worksheet to Another, please save and confirm that the file extension is with "xlsm" which means macro enabled worksheet.
If you want to solve this, pls send sample data and the code. Like names in xyz, numbers in 1234
