The best way way to join cell ranges in Excel is to use the CONCATENATERANGE formula. It gives you the option to format the results, and works with ALL versions of Excel. It is a better alternative to other formulas like TEXTJOIN, CONCAT and CONCATENATE. Here is a demo of the CONCATENATERANGE formula.
When code line numbers have been added to an Excel/Word VBA Project, the error-handling ability for the Project has been improved, but it’s sure hard to look at when you want to review/resume coding in the VBA Editor!
Use VBA Line Numbers with CodeLiner to remove code line numbers, which will enhance the readability of the code until you are ready to put the Project back into production.
Enhance code readability! Download a free trial!
When an Excel (or Word) VBA error occurs, the built-in Erl function is supposed to tell you the exact line where the error occurred, but it only works if you’ve added code line numbers to your VBA Project.
Use the VBA Line Numbers with CodeLiner toolbar to add the code line numbers. This will allow you to use the Erl function to identify the exact location of your error.
Save time finding errors! Save time adding line numbers! Download a free trial!
Instantly add and remove line numbers in your Excel or Word VBA Project by using the VBA Line Numbers with CodeLiner toolbar!
|Now supports Access and Word!||Download a free 3-day trial!|