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
.