Macro that counts all characters in Worksheet

  • I googled very many pages and forums, but I found nothing. So I am tryin to find VBA but I cant find my luck to resolve it:


    So what wrong with this code. Code must to show me message box that counts all characters in worksheet.


    Code
    Sub countchar()
    
    
    MsgBox Application.WorksheetFunction.SumProduct(Len(ActiveSheet.UsedRange))
    
    
    
    
    End Sub


    SumProduct(len(range)) is no macro solution but it doesnt work because of sumproduct expression in VBA...I dont know what should to do to figure out how to run this.

  • Re: Macro that counts all characters in Worksheet


    Check out this, may be it gives more information than you need !



    Source

  • Re: Macro that counts all characters in Worksheet


    Wow. It is more than I expected. Looks like in Word now. :angrypc: BIG thank you. It was really helpful. :wowee:

  • Re: Macro that counts all characters in Worksheet


    But I suddenly got error message..maybe it doesnt count activex button characters.


    Error:
    438: Object doesn't support this property or method.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!