Cincy, the address function have :

20 = row number
2 = column number

Change the number 2 for the new column the information is
a=1
b=2
c=3
etc

hth
regards from Brazil
Marcelo

"Cincy" escreveu:


Thanks. Both approaches worked but when I inserted a column in one of
the team worksheets I noticed the mentioned equations did not return
the correct result because it referred to a fixed cell in the team
worksheet.


--
Cincy
------------------------------------------------------------------------
Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172
View this thread: http://www.excelforum.com/showthread...hreadid=563010