excel: syntax for using a dynamic variable in SUM

82 views
Skip to first unread message

timepro timesheet

unread,
Jul 18, 2022, 7:07:37 AMJul 18
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 PMAug 10
to
Can you send a small example of the spreadsheet you are using
Reply all
Reply to author
Forward
0 new messages