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: | 251 |
Nodes: | 16 (2 / 14) |
Uptime: | 139:31:30 |
Calls: | 5,526 |
Calls today: | 3 |
Files: | 11,671 |
Messages: | 5,096,312 |