ExcelBanter - Summing a Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Summing a Range (https://www.excelbanter.com/excel-programming/274694-summing-range.html)

Hi Norma,

Application.Worksheetfunction.sum(range(cells(2,1) ,cells
(2,256))) give you the sum of row 2 regardless wheather
the cell is empty or no empty.

Best Regards

Bill

-----Original Message-----
I am working in VB for Aps. I am trying to sum a row of
cells, I don't know how many cells will be involved (the
number of cells will always vary). I am at a deadend!!
Anyone have any suggestions??

Norma
.

How about
Application.Worksheetfunction.sum(rows(2))
then.

--
Regards,
Tom Ogilvy

Bill Li wrote in message
...
Hi Norma,

Application.Worksheetfunction.sum(range(cells(2,1) ,cells
(2,256))) give you the sum of row 2 regardless wheather
the cell is empty or no empty.

Best Regards

Bill

-----Original Message-----
I am working in VB for Aps. I am trying to sum a row of
cells, I don't know how many cells will be involved (the
number of cells will always vary). I am at a deadend!!
Anyone have any suggestions??

Norma
.