Hi Philip, I changed manual to Application.Calculation = xlCalculationAutomatic now it is working fine But if it cause any other issue doing lik...
Hi Philip Could you make changes in that file ?
Hi Philip Here is the attached file for your reference. Please let me know if you need further information
Okay will finish all the code today or tomorrow If any issues will contact you here again Thank you so much again for your support Philip
Yes i tried it Now it is working fine for me Thanks for the support I have one more question - in last i put VLookup But i need vlookup for visible ce...
did you tried to run macro like that ? Is it working fine ?
Thanks for the solution But i don't know how to do that Can you make changes and send the revised file for me if possible ?
i will provide you the workbook with macro file Simply saying i want to Vlookup a filtered data only for visible cell I provided the information...
I have some data in col Z. If i found "Error" in col Z then i want to do vlookup in AA. If there is no "Error" in col Z then i dont want to Vlookup it...