Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

excel: syntax for using a dynamic variable in SUM

87 views
Skip to first unread message

timepro timesheet

unread,
Jul 18, 2022, 7:07:37 AM7/18/22
to
*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

poopall

unread,
Aug 10, 2022, 7:20:00 PM8/10/22
to
Can you send a small example of the spreadsheet you are using
0 new messages