Re: $$Excel-Macros$$ Want to add every third row or coloumn!

-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Want to add every third row or coloumn! Dear Sandeep, Select required range and run this code... Sub InsertSpecificRows() Dim InsQuan As Integer On Error Resume Next InsQuan = InputBox("Enter number of rows to insert", "Your Ca

Re: $$Excel-Macros$$ Want to add every third row or coloumn!

Dear Sandeep, Select required range and run this code... Sub InsertSpecificRows() Dim InsQuan As Integer On Error Resume Next InsQuan = InputBox("Enter number of rows to insert", "Your Call") If InsQuan <= 0 Then MsgBox "Invalid number entered", vbCritical, "Stop!" Exit Sub End If Application.Scr

Re: $$Excel-Macros$$ Want to add every third row or coloumn!

Hi Send sample file for more clarity Thanks On Tue, Jun 4, 2013 at 9:51 AM, wrote: > Dear expert, > Many time I have to add every third or every forth or every second row or > column etc...can you suggest a function which will ease my problem! Till > now I am adding required cell one by one