Summing a Range

[Bill Li]

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

 

[Tom Ogilvy]

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