NumberFormat = "#,#0.0" ' If Range("H10").End(xlDown).Row sSheetName And Worksheets ( iSheet ). If you have any doubt regarding this article or have any other questions. Try saving the file from the PC where it works as an xlsm file and try that file on the other PC. So yeah guys, this is how you can make CHAR (10) formula work. So your file contains some content the Excel version you are using does not like. Click on this option and you will see the CHAR (10) working successfully. In home tab -> alignment section - word wrap.
So there may be a chance that your excel workbook is got corrupted and thus the hyperlink inserted in it not working. Solution: To CHAR (10) work, you need to activate the word wrap. this error commonly occurs when code is incompaticle with the version, platform, or architecture of this application.
(NOTE: Planning to build or manage a VBA Application Learn how to build 10 Excel VBA applications from scratch. Related Training: Get full access to the Excel VBA training webinars and all the tutorials. Select Call ChangeCase ' Insert weight formulae Range ( "H10" ). In most situation it is seen that due to the corruption of Excel workbook you can’t perform any task in it. When I open the workbook, it has the following error window text and does not run anything: 'Compile error in hidden module: Mainscript. Free VBA Tutorial If you are new to VBA or you want to sharpen your existing VBA skills then why not try out the The Ultimate VBA Tutorial. VB.net Sub Trim_Format () ' Macro to sort colors and add subtotals - AMF 11-28-2007 ' Insert weight formulae Dim iTblRow As Integer Dim iGSumRow As Integer ' Upper case Job & Coil Number Range ( "A10" ).