VBA - Cut an instruction line in a macro

February 2017



Issue


I have a macro where I have a line that is too long (greater than 255 characters).
Is there any solution to cut it in several parts?

Solution


To cut an instruction line, leave a space before the underscore (_)
 a = Int((d - 1721061 - Int((d - 1721061) _ 
            / 1460.97) + Int((d - 1721061) / 36524.25) - _ 
                Int((d - 1721061) / 146097)) / 365) 

Related


Published by aakai1056. Latest update on November 28, 2011 at 11:05 AM by aakai1056.
This document, titled "VBA - Cut an instruction line in a macro," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).