Log In
Register
Home
August 3, 2020
Offline
Hi there,
In my VBA code there is a loop in column Y and there is formula in Column Z
Then i want to filter data "Success" in column Z
But i select only "Success" but not whatever the loop data in column Y
For example if i filtered manually "Success" there total number of rows filtered is 675
If i use macro then only 478 rows are visible
Could anyone please help me on this ?
October 5, 2010
Offline
Hi Arunachal,
Please attach your workbook.
Regards
Phil
August 3, 2020
Offline
Hi Philip
Here is the attached file for your reference.
Please let me know if you need further information
October 5, 2010
Offline
Hi Arunachal,
at the start of the Validation() sub you're setting calculation to manual mode Application.Calculation = xlCalculationManual
When you run Validation and filter the data the VLOOKUP formulae in some cells have not updated and are showing #N/A errors.
At the end of the Validation() sub you set calculation back to automatic and the #N/A cells with VLOOKUP update to the value "Success" hence the difference in the counts.
Not sure why you have calculation set to manual at the start of the Validation() sub?
Regards
Phil
August 3, 2020
Offline
Hi Philip
Could you make changes in that file ?
October 5, 2010
Offline
Hi Arunachal,
at the start of the Validation() sub just remove the line Application.Calculation = xlCalculationManual
Regards
Phil
August 3, 2020
Offline
Hi Philip,
I changed manual to Application.Calculation = xlCalculationAutomatic
now it is working fine
But if it cause any other issue doing like this ?
1 Guest(s)
