Inserting a Row with a Variable Row Number

I

Izran

Simple problem I believe, but I have a interger variable expression
(iEnd - 2) that identifies the row number I want to select to insert a
row. For the life of me, I cant seem to figure out how to do it. Any
help will be appreciated.

Regards,
Michael P Manzi
 
D

Dave Peterson

activesheet.rows(iEnd-2).insert

Maybe???


Simple problem I believe, but I have a interger variable expression
(iEnd - 2) that identifies the row number I want to select to insert a
row. For the life of me, I cant seem to figure out how to do it. Any
help will be appreciated.

Regards,
Michael P Manzi
Click to expand...
 
I

Izran

Yeppers. I knew it was something simple, but after 20 minutes of
pulling my hair out ot make it work..... Thanks a bunch.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to select and delete levels of a document 2
Inserting a Row with a Variable Row Number 1
Defining variables as row numbers 1
Reference a workbook level named variable. 8
Need macro to add numbers in rows 9
Automatically Combine Cell Contents and Delete Rows 0
Auto duplicate rows 0
Insert a Row - Variable Location 11

Top