Dec
28

Excel: VBA Examples-3

Get the max row cotain value of the sheet Sub GetMaxRow() n = Cells.Find(“*”, , , , 1, 2).Row MsgBox n End Sub Get the max row of column A which is not empty Sub GetMaxRowOfColumnA() n = Range(“a65536″).End(xlUp).Row Range(“B1″) = n End Sub Insert text frame in selected area Sub InsertTextFrame() For Each rag… Continue reading »

Dec
27

Excel: VBA Examples-2

Change the button name and loop around 3 macros.(Code of the button) Option Explicit Private Sub CommandButton1_Click() With CommandButton1 If .Caption = “macro1″ Then Call macro1 .Caption = “macro2″ Exit Sub End If If .Caption = “macro2″ Then Call macro2 .Caption = “macro3″ Exit Sub End If If .Caption = “macro3″ Then Call macro3 .Caption… Continue reading »

Dec
26

Excel: VBA Examples-1

Open all hidden sheets. Sub openallhiddensheets() Dim i As Integer For i = 1 To Sheets.Count   Sheets(i).Visible = True Next i End Sub loop example sub loopexample() AAA = Range(“C2″) Dim i As Long Dim times As Long times = AAA ‘times – means the loop times, set value to it before for loop(it… Continue reading »

Dec
24

Word:Tips to maxmize or restore the window.

You can adjust the window except the maxmize and restore button at the top right corner of the window. First, you can do this by double click the titlbe bar. Secnod, you can click the cross area of the scroll bar and the vertical bar.

Dec
24

Excel: Input in an area and don’t need swith between cells by mouse.

You can do this by following. Select an area by mouse. Then press Tab to move the cell forward and move the cell backward by Shift+Tab. By this way, you can input datas without mouse in order to improve productivity. By this way, if you are at the cell of the selected area, press Tab… Continue reading »

Dec
24

Word: How to find last modification?

I belive you must have this experience In some case you have a long word document with tens of pages and you want to go to the last modification to start work when you open the document. There is a short way to do this, Press “Shift+F5″ can go the last modification place. It’s very… Continue reading »

Dec
24

Office: How to copy the format?

Most word userknow, when select part of the word, press the format bruch button can get the format of the selected words. Use this brush can change the format of other words.But after this, the format brsuh not available any more. If you want to repeat the format brush, you have to repeat above steps.… Continue reading »

Dec
24

Excel: How to get the value of part of the formula?

When we make an excel sheet, sometime we need input a long formula. If there is only two or three formulas in the cell, it’s easy. If there is more than 3 formulas in a cell, it’s difficult to check the error in the cell. This tip help to make it easy. For example. If… Continue reading »

Dec
22

Excel: How to change the rows to columns?

After you finished a sheet, you find the rows and columns are not exactly what you want, you want to switch the rows and columns. How to do this? Select the cells at first, then copy them. Then select another empty sheet, right click the mouse, select “Transpose(T)” to paste the range.

Dec
22

Excel:How to hide cells?

Hide the value in all cells. Right click the cell, select “Format cells”->”Number”. Select Category->Custom input ;;;. You can also set the font of the text to white which is same as the background. This way is too common and easy to be cracked by others.

Older posts «