VBA to count rows from specific cell and insert rows
not sure where you want to start, but this may give you an idea on how to do
what you want
Worksheets("Sheet1").Range("A1").Offset(170).Resiz e(2).EntireRow.Insert
--
Gary
"Valerie" wrote in message
...
Within a macro I have a "found" cell (Find "US03" in certain column) which
can be on any row. I need code to count down 170 rows from this cell and
insert 2 rows. This is done from the top of the worksheet.
Thanks!!
Valerie
|