What does this mean in VBA?

excelos

Active Member
Joined
Sep 25, 2011
Messages
329
Hello

I generated a macro through the recorder and it generated the following code:

ActiveCell.FormulaR1C1 = _
"§ 4,795..............

What does the =_ mean?

Also, is it possible to use multiline text/code for the ActiveCell.FormulaR1C1 ?

Thanks!
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,615
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
The underscore is used to continue the line on the next line. If you have a line that is very long it can make reading easier if it is continued on the next line.
 

excelos

Active Member
Joined
Sep 25, 2011
Messages
329
That's great, so I can use _ to break code lines like that?

some code _
continuing with other code

instead of writing:

some code continuing with other code

?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,523
Messages
5,529,333
Members
409,863
Latest member
stacy09
Top