Tag: excel
Gather excel cells – Excel VBA
Just like word’s left alignment, the excel cells are aligned to the left. Download sample excel file If you have any suggestions or questions, please leave a . Thank you.
Making self-detructing excel file – Excel VBA
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 […]
Sort column by row’s color – Excel VBA
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. Download sample Excel […]
Divide column into other column by length – Excel VBA
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 […]
Mix rows without breaking the alignment of the columns – Excel VBA
Here is a special function of excel VBA that you can not do it with the excel formulas. Download : Sample Excel File Excel Trics&Training List If you have any […]
Solve : Excel file is running slow !
Please backup your file before trying. Then do this settings please. If you have any suggestions or questions, please leave a . Thank you.
Excel Learning Tricks & VBA & Formulas with Examples
Microsoft Excel 2010 is an extremely powerful tool and Visual Basic for Applications (VBA), a programming language that offers you the ability to extend those packages. Once you’ve got discovered […]
Export the words from the text – Excel VBA
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 […]
Easy row tracker with selection – Excel VBA
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 […]
Sort items by other column items – Excel VBA
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 […]