Search results
To continue a statement from one line to the next, type a space followed by the line-continuation character [the underscore character on your keyboard (_)]. You can break a line at an operator, list separator, or period.
7 lut 2020 · It's too long to fit on a line, so I'm using the line continuation character _ but it ain't working. When the code fits on a line, it does work, so I know it's not an issue with the command itself, just the length. How do I fix this?
26 lip 2021 · You can use the line continuation character (“_” aka the underscore) to continue a statement from one line to the next in your VBA code. The following code shows you how to use the line continuation character:
To continue a line of VBA code onto the next line, you can use the underscore (_) character at the end of the line where you want the code to break. It's essential to ensure there's a space before the underscore and no text after it on the same line.
10 cze 2024 · The underscore character at the end of the second line allows the statement to continue on the next line for readability. This code loops through a range of data, ignoring errors and continuing to the next iteration of the loop, and prints a message to the intermediate window for each row of data.
13 lut 2024 · You can improve the readability of your code by breaking it in the middle using space + underscore to continue the code on the next line. This article explains how to break code in VBA and provides practical examples.
To continue on the next line in Excel using VBA, you can use the underscore (_) character at the end of a line to indicate that the statement continues on the next line. Here is an example: vba Sub ContinueOnNextLine() Range("A1").Value = "This is a long sentence that will continue on the next line " & _
