Macro to add cell below to activecell

Hi, thanks in advance for reading this. Our office recently moved from WordPerfect and Lotus to Office 2003 (bought on sale since Office 2007 was released). I want to start using Excel right away because of some of its features, but am having trouble with macros - I'm not a VBA programmer, and even when I think I've got it right I end up messing it up. The main macro I want to convert is so simple it's probably silly. In my worksheet there are two rows: row 1 has a value of 20, row 2 has a value of 1.30 . I want the value in row 1 to be 21.30 and row 2 to be deleted. There are multiple instances of this in the worksheet. I would highlight the cell in row 1, and the macro in Lotus was:

21.3~{D}/wdr~

I seem to be having a problem with relative locations. It always ends up NOT changing the value to 21.3 and instead deletes each row.

Any help I can get is appreciated - thanks again!

Mike

VBA Noob, thanks for the quick response! That works very well, but is there a way to get it to drop down to the row where the cell is now empty and delete the entire row?

Thanks!

Mike

This is even better! I occasionally get multiples of 21.30 (42.60, 63.90) that I always did by hand, this works for all of them! My main frustration was "moving the cursor" in the macro. Lotus was simply DOWN, UP, LEFT, RIGHT. I see here, after you dimensioned rng for the macro, that you used the "Rng.Offset(1) " command. If the offset was (-1) would that be the row directly above? How about moving left and right, what would I have used to go left one column?

Thanks a bunch!

Mike