*how to syntax a dynamic variable (THETAXPERC) in 'sum'
for jc=nstart to xrow
xvar1="P"+alltrim(str(jc));xvar2="Q"+alltrim(str(jc)) oSheet:cells(jc,21):value="=sum("+xvar1+"+"+xvar2+"/"+THETAXPERC")"
next
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 64:04:52 |
Calls: | 6,488 |
Calls today: | 1 |
Files: | 12,096 |
Messages: | 5,274,793 |