Can anyone explain why the following code (counting characters in a range) returns an error (2029)?
Sub CountChar()
set rng - ActiveSheet.Usedrange
rng.select
x = Evaluate("sum(Len(Selection)")
MsgBox x
End sub
Ps: The array is correctly evaluated when a definite range (say "a1:d10" is substituted for selection.
Bookmarks