learn to write vba code for excel

Sometimes, we want to add a slash header in Excel, but Excel does not provide the function of making slash head, each time to draw a slash manually, very troublesome. Is there a solution? In fact, we can use VBA code can write a function, a key insert

There are many ways to delete empty rows and columns in exce, it is relatively simple to delete empty rows, just filter, filter out blank lines, Delete them, But it is difficult to delete empty Columns. Because you cannot filter by column to Delete. This feature is not in Excel. Of course you can use another method, that is, sort by column, sort the blank columns together, and then delete, but this method faces the problem that the order of the column

In Excel, there is no conversion between simplified and traditional text. But word has this feature, so we can call the traditional and simplified features of Word in Excel by using VBA code to realize the functionality of simplified traditional translation in Excel. Here

Typical Excel VBA code application (EXCEL program) Application. enableevents = true/false' enable/disable all events Application. displayalerts = true/false' display/Close warning box prompt box Application. screenupdating = true/false' display/Close screen refresh Application. statusbar = "" 'displays text in the

Using the following VBA code, you can count a character or a number, or even a string, within a range of data regions, several times, or several, in Excel. The code below is the VBA macro code. Set Myb = CreateObject ("Scripting

Mycolumn=target.column Gets the column number of the active cell Myrow=target.row gets the line number of the active cell The name of the worksheet. UsedRange.Rows.Count Specify the total number of rows used by the worksheet The name of the worksheet. UsedRange.Columns.Count Specify the total number of columns used by the worksheet The name of the worksheet. Cells (line number, column number). Value gets the values of a cell on the specified worksheet Worksheets (m). Cells (i, J). Value use

In Excel, you create the hyperlink code in bulk (connect to sheet in the current document), and in column B in Sheet1, you create a series of hyperlinks that are the other sheet in this document, such as creating a macro under Sheet1 code as follows.SUB Macro 1 ()Dim Temp, Temp2Dim I, Jj = 1For i = 5 to 74temp = "' G" J "'! A1 "Temp2 = "G" JRange ("B" i). Sel

How to make an Excel file that is limited to open on a computer and other computers cannot open the Excel file. This has to be done with the help of VBA code. Just add the following code to the event that the workbook opens. Private Sub Workbook_Open () application.scree

In Excel, using the simple visualization method is difficult to filter by color, so we can only use VBA code to implement it. The following code has the function of hiding the column data of the current cell with the row of the current cell in addition to the first row, the header column of the data. If you have othe