Hi,

I'm working at calculating an average from a range of cells. The rang
is in another excel file, and is selected from user inputs.

This is what i have so far:

Workbooks.Open Filename:=file_name
Initial = "b" & w_row
Final = "b" & counter
range(Initial & ":" & Final).Select

This is where I get stuck...do i need to store these values in an arra
or is there a formula to calculate the average of range(Initial & ":"
Final)

Thanks in advance,
Dan

--
Dan
-----------------------------------------------------------------------
Dani's Profile: http://www.excelforum.com/member.php...fo&userid=2354
View this thread: http://www.excelforum.com/showthread.php?threadid=37706