Hi,
I am modifying some code for a user form. But have came across a (To many line continuations) message.
The “And r Offset” lines are causing the errors.
Could I just have once continuous line?
I am modifying some code for a user form. But have came across a (To many line continuations) message.
The “And r Offset” lines are causing the errors.
Code:
Do
'New-----------------------------------------------------
If r.Offset(0, 1) = NumRepl _
And r.Offset(0, 2) = BARepl _
And r.Offset(0, 3) = PriceRepl _
And r.Offset(0, 4) = testRepl _
And r.Offset(0, 5) = hoursRepl _
And r.Offset(0, 6) = weeklyhoursRepl
And r.Offset(0, 7) = typeRepl _
And r.Offset(0, 8) = pcteleveldateRepl _
And r.Offset(0, 9) = sptelleveldateRepl _
And r.Offset(0, 10) = pcpaperleveldateRepl
And r.Offset(0, 11) = sppaperleveldateRepl _
And r.Offset(0, 12) = skrmleveldateRepl
And r.Offset(0, 13) = pcspecialistleveldateRepl _
And r.Offset(0, 14) = spspecialistleveldateRepl _
And r.Offset(0, 15) = teamleaderleveldateRepl _
And r.Offset(0, 16) = skskleveldateRepl _
And r.Offset(0, 17) = pctelevelRepl _
And r.Offset(0, 18) = sptellevelRepl _
And r.Offset(0, 19) = pcpaperlevelRepl _
And r.Offset(0, 20) = sppaperlevelRepl _
And r.Offset(0, 21) = skrmlevelRepl _
And r.Offset(0, 22) = pcspecialistlevelRepl _
And r.Offset(0, 23) = spspecialistlevelRepl _
And r.Offset(0, 24) = teamleaderlevelRepl _
And r.Offset(0, 25) = sksklevelRepl Then
r = Me.txtDescription
r.Offset(0, 1) = NNumRepl
r.Offset(0, 2) = NBARepl
r.Offset(0, 3) = NPriceRepl
r.Offset(0, 4) = NtestRepl
r.Offset(0, 4) = NpctellevelRepl
Exit Do
Could I just have once continuous line?
Last edited by a moderator: