Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565432