Hello,
I have a bunch of excel files with several worksheets.

On the worksheet named TA in all files i have two cells R11 and R13, these
hold the row numbers of a begin and end point entered by the user
respectively.

I am having trouble writing a simple macro that will replace a range of
values in column K with the value of cell C2 after the user tabs out of
entering the value of R13.

C2 contains the formula =AVERAGE(B2:B150)

The range of K is determined by the values in R11 and R13.

Example:
C2 has the value .0013
R11 has the value 15
R13 has the value 25
After the user enters 25 in R13, cells K15 through K25 now have the value .
0013

Any assistance would be greatly approached. Thank you.

--
Message posted via http://www.officekb.com