tuna-kichi https://blog.hatena.ne.jp/tuna-kichi/ Excelのこととか色々 https://www.tuna-kichi.com/ Excel VBA Macros Ribbon Efficiency beginners COUNTIF copy and pastevalue COUNTIF function can be used when calculating how many same date is exists or checking same data is no duplicated. However, this function makes your computer slow because it re-calculates every time the sheet is refreshed. This macro shows only the result of function. 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.tuna-kichi.com%2Fentry%2FCopyPasteValues_en" title="【Excel/VBA 05】Copy and Paste Value Macro - Excelのこととか色々" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> https://cdn-ak.f.st-hatena.com/images/fotolife/t/tuna-kichi/20200223/20200223230814.png Hatena Blog https://hatena.blog 2021-08-13 14:37:36 rich https://www.tuna-kichi.com/entry/CopyPasteValues_en 1.0 100%