Insert Cells

  • Thread starter Thread starter venkat
  • Start date Start date
V

venkat

Hi,



I want to select 2 cells in column wise from the active cell and
need to insert 5 cells between them (using
"XlInsertShiftDirection.xlShiftToRight". Can any one tell me the way to do
this task?



Thanks in advance,

Venkat
 
How about just selecting one cell in the column and inserting 5 cells after it.

activecell.offset(1,0).resize(5,1).insert shift:=xldown

If you wanted to insert 5 complete rows, you could use:
activecell.offset(1, 0).resize(5, 1).entirerow.insert
 
You must log in or register to reply here.

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

Inserting a Copied Row inside a table 6
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Copying Row Code Doesn't Copy Conditional Formating 10
Locating differences in text when comparing two cells 10
Macro to insert a line when a value changes in a range 1
Dynamic border formatting based on dates. Use VBA? 1
Insert Cell with IF Formula 0
Drop down menu 2

Back
Top