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
.