Message-ID:

7 May, 2024: fms is rebuilding. Don't expect much in that section for quite a few days, maybe longer.

devel / comp.lang.xharbour / excel formula/macro

excel formula/macro

<ad3874fd-c2aa-4a34-b1a3-7dfc1bb43391n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=17404&group=comp.lang.xharbour#17404

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:a05:622a:93:b0:3d5:bb6:9240 with SMTP id o19-20020a05622a009300b003d50bb69240mr5242294qtw.4.1683652858100;
Tue, 09 May 2023 10:20:58 -0700 (PDT)
X-Received: by 2002:aca:bf56:0:b0:390:7dca:9829 with SMTP id
p83-20020acabf56000000b003907dca9829mr876811oif.10.1683652857813; Tue, 09 May
2023 10:20:57 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!feeder1.feed.usenet.farm!feed.usenet.farm!peer02.ams4!peer.am4.highwinds-media.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Tue, 9 May 2023 10:20:57 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=2405:201:3d:94f:18ce:f1bb:bc9c:35c;
posting-account=jZAeNwoAAABYWjMRM-FfqKkHfC3Iph0l
NNTP-Posting-Host: 2405:201:3d:94f:18ce:f1bb:bc9c:35c
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ad3874fd-c2aa-4a34-b1a3-7dfc1bb43391n@googlegroups.com>
Subject: excel formula/macro
From: timecosting@gmail.com (timepro timesheet)
Injection-Date: Tue, 09 May 2023 17:20:58 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1434

by: timepro timesheet - Tue, 9 May 2023 17:20 UTC

hello everyone:

-substitute/instead of:
for jc=nstart to xrow-1
oSheet:cells(jc,16):value="="+"S"+alltrim(str(jc))+"+"+"T"+alltrim(str(jc))+"-"+"E"+alltrim(str(jc))
next

-to:
osheet:range(osheet:cells(nstart,16),osheet:cells(xrow,16)): WHAT CODE/SYNTAX/FORMULA HERE?
e.g.: cellP = cellS+cellT-cellE

thank you.

Subject	Author
excel formula/macro	timepro timesheet