ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Splitting Long Line (https://www.excelbanter.com/excel-programming/329630-splitting-long-line.html)

Dale

Splitting Long Line
 
I use excel 2003. When writing macros with long lines of code, what is the
correct way to split the lines to make them easier to print the code?

Chip Pearson

Splitting Long Line
 
Use the line continuation characters, a space followed by an
underscore. E.g.,

Workbooks.Open _
filename:="C:\Test.xls"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Dale" wrote in message
...
I use excel 2003. When writing macros with long lines of code,
what is the
correct way to split the lines to make them easier to print the
code?





All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com