Convert Formulas İn Selected Cells To Value 2 Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub metnecevır() Col = 1 DerLig = Cells(65536, Col).End(xlUp).Row For i = 1 To DerLig Cells(i, Col).Formula = "'" & Cells(i, Col) Cells(i, Col).Formula = "" & Cells(i, Col) Next i 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 convert formulas in selected cells to value 2 2 excel operators hk 3 convert formulas to numbers 4 convert formulas to numbers 5 convert formulas in selected cells to value 6 convert formulas to value 7 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. 8 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. 9 Convert Day to Day: if you have a date on your worksheet and want to convert all these dates into days, this code is for you. Just select the range of cells and run this macro. 10 converts the number in the cell to lower or upper case and normal. h2o co2 11 convert 12 Find and select the remaining cell in the value between 2 selected numbers 13 converts text to uppercase & lowercase 14 converts text to uppercase & lowercase 15 Convert all texts in the selected region to lower case 16 Convert to Uppercase: Select cells and run this code. Checks each cell of the selected range and then converts it to uppercase text. 17 Convert Small Case: This code helps you convert selected text to lower case text. & Nbsp; Select a range of cells that contain your text and run this code. If a cell has any value other than a number or text, the value will remain the same. 18 Convert selected cells to uppercase or lowercase with one click 19 selects full cells and converts them to uppercase 20 selects full cells and converts them to lower case