Bob,

Range("a1").copy range("b1") <=== B1 takes properties of A1

Range("b1")=Range("a1") <=== B1 retains its properties

HTH

"Newguy123" wrote:


I am tracking 32 sports teams. I have various stats the I would like to
get averages from. Each team is on a row from 4-35. In column E are
total yards, column F is total attempts, I would like column G to be the
average, I would like the formula to calculate it for each individual
team.


--
Newguy123
------------------------------------------------------------------------
Newguy123's Profile: http://www.excelforum.com/member.php...o&userid=31117
View this thread: http://www.excelforum.com/showthread...hreadid=507849