Okay, clear, but since I do not use Outlook on my system and do not have Office 365 I cannot help you. Sorry. I'm sure someone else here can he...
It seems it's hard to answer: What version of Office (Excel) are you using ? That's not such a difficult question.
Just to point out, you can use the ISERROR function and set it to return whatever you want
Hi José, The solution is to create a copy of that worksheet without the macros and email that as an attachment. I don't use Outlook but the ide...
My system OS W11-64 bit Intel Core i7-6700 3.4GHz 16 GB Ram
I wrote a small vba module to do the process of opening the file, calculate the worksheet and then save and close the file: The results Using...
Hi Chris, Got the file, will see what I can tell you later today
What version of Excel are you using?
You're welcome, hope you make it to see the final result 😉
The result will have to show something, a blank or a 0but if you perform calculations on these columns a blank cell might cause issues. What you ca...
I haven't looked but Trnaspose can paste from column to row and v.v.
You could write a macro, and if you create a copy of your file and use find and replace where you change the sensitive contents to something different...
Hi, I don't know if you have looked at the file but I'm curious to know why you have a worsheet with 314 columns If I look ate the owssvr sheet th...
I don't think you can change it, maybe it's a regsitry setting