Just like word’s left alignment, the excel cells are aligned to the left. If you have any suggestions or questions, please leave a . Thank you.
You can think at first that such a code is strange. But you may need this code. Or you can use your friend to joke. The VBA code in this excel file was set to kill itself after 11 seconds. The file will be deleted before you examine it. So when the excel file […]
You can to sort lines by color without distorting line alignments. You can examine the sample vba excel file and modify it according to your own project. If you have any suggestions or questions, please leave a . Thank you.
In this excel VBA example, the date and time are united in the column. The length of the date is 11 characters and the time is 8 characters. The VBA code I prepared to separate them into two separate columns: date and time. You can modify the character lengths and division of your excel VBA […]
Excel Learning Tricks & VBA & Formulas with Examples Curriculum : 01 – Excel VBA: Show the Developer tab to Excel 02 – Excel VBA: Export the words from the text with Example 03 – Excel VBA: Easy row tracker with selection with Example 04 – Excel VBA: Sort items by other column items with […]
Actually this is a word analysis application made with excel VBA. I was working English vocabulary and I needed something like this. I had to sort out the words in the movie subtitles. But this was a time-consuming process. There are a few programs that have been made for this. But there is no need […]
Here is a special function of excel VBA that you can not do it with the excel formulas. The row background will be completely yellow and the font size will increas when you click the any cell of row. So you can easily find the items. You can change the color and size options […]
This sample is sorting a column items by other column items. You can this process by excel formulas. But,this means a lot of code dump. So I showed you how to do it with excel VBA codes. If you have any suggestions or questions, please leave a . Thank you.
Change the items of any column with the other items. Actually , this is just Ctrl+H function. Of course, you can develop these codes indefinitely. If you have any suggestions or questions, please leave a . Thank you.