excel - VBA method 'range of object' _Worksheet failed varibles used in range declaration - Stack Overflow

excel - VBA method 'range of object' _Worksheet failed varibles used in range declaration - Stack Overflow:

Sub, like a Function procedure, is a separate procedure that can take arguments, perform a series of statements, and change the value of its arguments. However a Sub procedure doesn't return a value like a Function does.

Sub and Function both take arguments; only Function returns a value!