Inserting a Row with VBA
Try this
Selection.EntireRow.Insert
ActiveCell.Offset(2, 0).Select
Lars Kofod
-----Original Message-----
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
.
|