Inserting Multiple Rows in Excel using VBA 1

[arbeeone]

Hi,
I want to insert multiple rows into a worksheet using VBA.
I can insert a single row using:
Rows(r).Insert - where r is the row number
But, Rows(r:r1).Insert (where r1 is the last row number) doesn't work. I've tried using the Cells method for the Range but this also gives me problems. I can use a loop to insert single lines from 'r' to 'r1', but I suspect a single command would be more efficient (and neater!).

Any help would be greatly appreciated!

rsb

 

[fredericofonseca]

Use the macro recorder and then look at the code created.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[arbeeone]

I've tried this, but the problem is that the macro recorder gives specific row numbers (e.g. Rows("10:11") ) but I want to have them as variable names. I've tried Rows("r:r1") and Rows(r:r1) but neither seem to work.
rsb

 

[xlbo]

well use a bit of logic then

rows(StartRow & ":" & EndRow).delete

Alternatively

Range("A1:A10").entirerow.delete would work

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[arbeeone]

Thanks Geoff,
I'd tried 2 or 3 different combinations of concatenation but not that one!
rsb