Numbers And Codes From A1 To B1 Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub Zeichen_auslesen() Range("B1").Select ActiveCell.FormulaR1C1 = "=CHAR(ROW(RC))" Range("A1").Select ActiveCell.FormulaR1C1 = "=CODE(RC[1])" Range("A1:B1").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .ShrinkToFit = False .MergeCells = False End With With Selection.Font .Name = "Arial" .Size = 12 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With Selection.Font.Bold = True Selection.AutoFill Destination:=Range("A1:B255"), Type:=xlFillDefault Range("A1").Select End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 Numbers and codes from a1 to b1 2 excel operators hk 3 codes to manually select the rows and columns you want to print 4 specify the number of copies to print from the printer 5 Type b1 from a1 to sequence number 6 translate the number / number into English (in dollars and cents) 7 output as many as the number in the cell 8 separates numbers from letters and numbers in a column 9 Extracting values from cells 10 delete duplicate / duplicate rows 11 Remove Characters from a Directory: Remove only characters from the beginning of a text string. All you need is to reference a cell or add a number of characters and text to the function to remove from the text string. There are two arguments,rng" for the text string andcnt" for the number of characters to remove. for example: 1 incnt if you want to remove the first characters from a cell; 12 sum of numbers from 1 to 10 with variable and loop 13 dictionary codes 14 inserts months as sheet / pages Specifies days in detail 15 Print Custom Pages: You can use this code to print a range of custom sheet / pages instead of using the setting from the print options. Suppose you want to print sheet / pages 5 to 10. Just run this VBA code and enter the start sheet / page and end sheet / page. 16 browse folder xls list 17 convert double and single lines into different colors and designs (one line is bold and the other line is normal) 18 macro to show ip number 19 Â Pivot Table These codes help you make and manage some changes to pivot tables in a flash. Hide Pivot Table Subtotals: If you want to hide all subtotals, simply run this code. first make sure that you select a cell from the pivot table and run this macro. 20 sort arithmetic from row or column