Counting numbers in Word VBA

[JamesWood]

Hi guys


Strange one here, but any idea how to COUNTA in Word VBA, not Excel? Or the equivalent? I'm aware this sub is totally wrong but hopefully it'll get across what I want to do:


Public Function MergeFromToTotal() As String


MergeFromToTotal = CountA(Range(Me.FromThis.Value:Me.ToThis.Value))




End Function


Where Me.FromThis.Value is a textbox that might contain any number, and the same for the ToThis value. If it was say 3-6 then I'd want MergeFromToTotal to return with 4 (e.g. 3, 4, 5, 6).


Hope that makes sense?


Thanks a lot!
James