ExcelBanter - Rows vb statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rows vb statement (https://www.excelbanter.com/excel-discussion-misc-queries/262384-rows-vbulletin-statement.html)

Rick

Rows vb statement

After using macro recording for a single insertion of a row, the recording
showed this:
Rows("50:50") followed by in inser command, my question is How do I make
this Rows statement become Macro friendly?

Dave Peterson

Rows vb statement

Maybe
Activecell.entirerow.insert
or
Activecell.offset(1,0).entirerow.insert

Rick wrote:

After using macro recording for a single insertion of a row, the recording
showed this:
Rows("50:50") followed by in inser command, my question is How do I make
this Rows statement become Macro friendly?

--

Dave Peterson

All times are GMT +1. The time now is 07:15 PM.