hi.
sorry so late getting back. i usually to ms groups while at work.

i still see no solution for you. the adding rows in the key. code just does
what it's told. it doesn't keep records about the number of rows that may
have been added or removed sometime in the past and automaticly compensate.
I'm sure it could be done by identifing B177 from maybe the bottom and as a
variable instead of a hard reference but without seeing the data i don't know
what to suggest.
if you want, send me the file and i will see what i can do.



Regards
FSt1


"mgmcdevitt" wrote:


It is a complicated explanation, but I have about 20 similar macros
written. Each of the macros are initiated by pressing an object in a
table. Then the corresponding values for what you have selected are
entered in the cells.

For Example: Our company has offices in CA, CO, and NM. Each office
uses different wages for each of their employees. Each office is using
the same worksheet and I want each office to be able to select their
office in the table and their wages to be used in the spreadsheet. When
the office selects their office in the table by pressing the button
their wages are pulled from a large table with the info from all the
offices.


--
mgmcdevitt
------------------------------------------------------------------------
mgmcdevitt's Profile: http://www.excelforum.com/member.php...o&userid=26592
View this thread: http://www.excelforum.com/showthread...hreadid=398608