I searched the Microsoft Knowledge data base and found a work around but not a fix except to buy a newer version. Here the link: http://support.microsoft.com/default...&Product=xlw2K

the 186047 is the article number. I report if i can figure out a better work around other then creating a new worksheet just before recording a new macro. My initial thought is to go to a blank cell in the worksheet that will not be used and Turn on the recorder and enter a number , change the color of the font to white, then create the rest of the macro. Once I review the macro on the code page make the reference to the first entry absolute by entering $ in the cell reference. Just a thought.

mike in Wisconsin