tuna-kichi https://blog.hatena.ne.jp/tuna-kichi/ Excelのこととか色々 https://www.tuna-kichi.com/ Excel VBA 初心者英語 Macros Ribbon Efficiency You can select cells from the the first to the end if press Ctrl + Shift + Arrow key. However, if there is a blank cell or cells are merged, you cannot reach to the end. This macro reaches the end cell even if there are hundreds of blank cells or cells are merged. 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.tuna-kichi.com%2Fentry%2FCopyColumn_en" title="【Excel/VBA 04】Select and Copy to The End Row LastRow/Selection） - 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/20201024/20201024121054.png Hatena Blog https://hatena.blog 2021-04-24 15:02:16 rich https://www.tuna-kichi.com/entry/CopyColumn_en 1.0 100%