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

MINUS...in excel (a la SUM)

59 views
Skip to first unread message

timepro timesheet

unread,
Jul 19, 2021, 1:32:58 AM7/19/21
to
hello all:

syntax to minus cellX from cellY and write the value in cellZ
my sum func:
for xx=xs1 to xs2
oSheet:Cells(xrow,xx):Value="=SUM("+oSheet:Range(oSheet:Cells(nstart,xx),oSheet:Cells(xrow-1,xx)):Address( .F.,.F.)+")"
next

how to copy/replicate all data(cells) from one sheet(tab) to another of the same excel file.

poopall

unread,
Nov 22, 2021, 11:55:19 PM11/22/21
to

poopall

unread,
Nov 23, 2021, 12:11:22 AM11/23/21
to
oSheet:Cells(xrow,xx):Value = "

Example:

If you wanted a formula which ADDS then

oSheet:Range("C1" ):Formula = "=A1+B1"

If you wanted a formula which SUBTRACTS then

oSheet:Range("C1" ):Formula = "=A1-B1"

If you want to create a SUM formula then

oSheet:Range("E1" ):Formula = "=sum(A1:D1)"

etc

Anything that you want excel to have you can write as :Formula

Hope that helps
0 new messages