Selecting Only Numbers İn The Selected Field (selecting Only Manually Entered Numbers Without Formulas) Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub sadece_sayi() On Error Resume Next Selection.SpecialCells(xlConstants, xlNumbers).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 Selecting only numbers in the selected field (selecting only manually entered numbers without formulas) 2 excel operators hk 3 delete duplicate / duplicate rows 4 collects selected fields in status bar 5 Identify and select only empty cells in the selected area 6 printing and prompting 7 Find and select the remaining cell in the value between 2 selected numbers 8 prevent deletion of formulated cells 9 Detecting and selecting rows with single row numbers 10 specifies in detail how many formulas are in the book (on new sheet / page) 11 inserts months as sheet / pages Specifies days in detail 12 Inputbox add year as summer 13 list formulas on new sheet / page 14 Assigning random numbers as a value to cells in the selected region 15 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; 16 locks only formulated cells on sheet / page others remain open 17 Extract only numbers contained in a text 18 Square Root Calculator: You can use this code to calculate the square root without applying a formula. checks all selected cells and converts numbers to square. 19 Calculate Cube Root: You can use this code to calculate the cube root without applying a formula. Checks all selected cells and converts numbers to cube roots. 20 write the number you want to be colored on the sheet / page in msgbox