#name!

[hanif]

Hi all,

I have the below code to sum a range of valued in the last colum but the return value is #NAME! does anyone know where am I going wrong?

Please Login or Register  to view this content.

Thanks

[hanif]

I also tried the below code and I am getting an erorr message saying "Unable to get the Sum poperty of the worksheetfunction class.

Please Login or Register  to view this content.

[bakerman2]

Try this.

Please Login or Register  to view this content.

[hanif]

Hi Bakerman,

Thanks for the reply. It still doe not work. after running the code the cell shows blank but when I click on the cell shown 0 in the formula bar

[hanif]

Thanks bakerman I was able to fix it but your reply helped a lot to get that fixed.

[bakerman2]

Just to show you that it does work.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[bakerman2]

Glad you figured it out. Thanks for the rep points.