I hope I can make this clear.
I have been doing great with VBA as long as I can express my cells and ranges using the Cells(i,j) format in my code. Recently I wanted to use some ready made functions in excel like AVG, PERCENTRANK, STDV, and I noticed that I can't get these functions to accept my ranges which are defined using the cells(i,j) format.
Example:
works fine
while
doesn't
Anything that I'm missin?
I'm very impressed with the help that I have been finding here and I'm sure this one will be no exception
Thanks Folks