Excelのこととか色々

マクロをどんな Excel ファイルにも実行できるように設定して、3秒かかる操作も1秒で完了。あといろいろ書いてみます・・・

Ribbon

【Excel/VBA】AutoFilter, Filtering For Blanks or Not Blanks

This macro filter for blanks or non-blanks by one click. I take "Split" function just I learned and array for this macro. You will see how to get the range of the AutoFilter, and this made my macro works on any Excel books

【Excel/VBA】Select and Copy to The End Row LastRow/Selection)

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 c…

【Excel/VBA 03】Adjust Row Height and Column Width by One Click

You can adjust the row height or the column width by one click if you create the macros and add them to the Ribbon. Write the macro on the Personal Macro Book thus you can use them on any Excel files.

【Excel/VBA 02...Insert Row/Column By One Click】

Adding a row or a columns is just one sentence of code. Set it to the ribbon and use them anytime.

【Excel/VBA 01...Personal Macro Workbook and Developer Tab】

Set your macros on the ribbon and you can use them anytime. That makes your work speeding up and reducing stress!