H
Heiko K Stugg
Easy One....but how do you break up a formula in VB so that you can see it on
the screen without having to scroll right?
the screen without having to scroll right?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David F Cox
use _
to _
join _
lines
to _
join _
lines
H
Heiko K Stugg
I assume you mean something like this?
TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]
--
Heiko K Stugg
TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]
--
Heiko K Stugg
David F Cox said:use _
to _
join _
lines
J
James
Yes but you need a space at the end between your code and the _
James
James
I assume you mean something like this?
TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]
H
Heiko K Stugg
Works well!!!
Thanks
--
Heiko K Stugg
Thanks
--
Heiko K Stugg
James said:Yes but you need a space at the end between your code and the _
James
I assume you mean something like this?
TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]
--
Heiko K Stugg
David F Cox said:use _
to _
join _
lines
Easy One....but how do you break up a formula in VB so that you can see it
on
the screen without having to scroll right?
T
Terry Kreft
Note there is a limit (24) to the number of line continuation characters you
can use in one statement.
--
Terry Kreft
can use in one statement.
--
Terry Kreft
Heiko K Stugg said:Works well!!!
Thanks
--
Heiko K Stugg
James said:Yes but you need a space at the end between your code and the _
James
I assume you mean something like this?
TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]
--
Heiko K Stugg
:
use _
to _
join _
lines
Easy One....but how do you break up a formula in VB so that you can see it
on
the screen without having to scroll right?