{"title":"\u3010Excel/VBA 05\u3011Copy and Paste Value Macro","width":"100%","published":"2021-08-13 14:37:36","blog_url":"https://www.tuna-kichi.com/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.tuna-kichi.com%2Fentry%2FCopyPasteValues_en\" title=\"\u3010Excel/VBA 05\u3011Copy and Paste Value Macro - Excel\u306e\u3053\u3068\u3068\u304b\u8272\u3005\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","author_url":"https://blog.hatena.ne.jp/tuna-kichi/","provider_url":"https://hatena.blog","blog_title":"Excel\u306e\u3053\u3068\u3068\u304b\u8272\u3005","url":"https://www.tuna-kichi.com/entry/CopyPasteValues_en","description":"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.","provider_name":"Hatena Blog","type":"rich","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/t/tuna-kichi/20200223/20200223230814.png","height":"190","categories":["Excel","VBA","Macros","Ribbon","Efficiency","beginners"],"author_name":"tuna-kichi"}