Hi all,
I have the following table:
1am 2am 3am 4am 5am
1 2 3 4 5
The inputs of this program is the hours, for example, from 3am to 4am.
Then, the average will calcuate (3+4)/2 ...
Since I dont know what the user will input, I cannot use A1,B1 .. or index ...
How can I specify an array containing the data?
I was thinking since Range(Cells(1,3),Cells(1,4)) refers to A3:A4, then
Average(" Range(Cells(1,3),Cells(1,4))") should work but it doesnt ...
It should be a variation of the above ... but I dont know what that is.
Any help is appreciated !! Thanks!!
Kim