VBA - Cut an instruction line in a macro

Ask a question


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) 

Excel - The ATAN function
Printer selection in Excel macro