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?
Thanks![]()
Please Login or Register to view this content.
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?
Thanks![]()
Please Login or Register to view this content.
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.
Try this.
![]()
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
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
Thanks bakerman I was able to fix it but your reply helped a lot to get that fixed.
Just to show you that it does work.
Perhaps.
![]()
Please Login or Register to view this content.
If posting code please use code tags, see here.
Glad you figured it out. Thanks for the rep points.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks