View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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?