MINUS...in excel (a la SUM)

49 views
Skip to first unread message

timepro timesheet

unread,
Jul 19, 2021, 1:32:58 AMJul 19
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 PM (6 days ago) Nov 22
to

poopall

unread,
Nov 23, 2021, 12:11:22 AM (6 days ago) Nov 23
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
Reply all
Reply to author
Forward
0 new messages