Hello All, Please help to run my code, I am not able to figure out.
Any help will be highly appreciated.
Welcome to the community
its a vba issue..better to run macro in excel and check where and why it is failing..looks like the field is missing or the filter is not applicable for field
cheers
Thanks.
Issue is that the same code is running perfect in our companies old Citrix version.
Is there any issue if we run it in new MS Office version or New Citrix version?
Instead of giving ActiveWorkbook or ActiveSheet, use specific sheet name or workbook name.
For that you need to manually run same in that and check
is it occuring for different types of data or for any specific file? this helps in getting to the issue
as said better to debug the vba in excel on citrix directly
1004 can occur for different reasons including the data variations or the way sheet is used as well
cheers