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.
On Monday, 19 July 2021 at 3:32:58 pm UTC+10, timec...@gmail.com wrote:oSheet:Cells(xrow,xx):Value = "
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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 171 |
Nodes: | 16 (1 / 15) |
Uptime: | 12:29:52 |
Calls: | 3,402 |
Calls today: | 10 |
Files: | 10,830 |
Messages: | 3,208,964 |
Posted today: | 1 |