On Fri, 28 Nov 2003 04:59:30 -0700, Thomas M wrote:

Excel 2000

This is driving me nuts!

All I want to do is insert a row at the current position, then move down
two rows. I recorded a macro, but the resulting macro contains A1-style
references. The macro needs to be dynamic, so it needs to use R1C1-style
references.

I've done this type of thing before, but can't for the life of me
remember how. I tried the online "Help", which was utterly useless. It
appears the Microsoft has done a fine job in totally burying any
informaiton that would actually be useful in solving this problem.

Does anyone know how to do this?

--Tom

ActiveCell.EntireRow.Insert
ActiveCell.Offset(2).Select
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
Misfortune: The kind of fortune that never misses.