Results 1 to 6 of 6

insert rows/columns

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2009
    Location
    Karachi
    MS-Off Ver
    Excel 2007
    Posts
    26

    Post insert rows/columns

    Hi to all!

    I have 3000 rows in a sheet. I'm using following code to insert blank row becasue i need to create space between two rows.

    Sub InsRows()
    Dim LR As Long, i As Long, j As Integer
    LR = Cells(Rows.Count, "A").End(xlUp).Row
    For i = LR To 2 Step -1
    Rows(i).Insert
    Next i
    End Sub
    Now the problem is that i need also to insert a blank column between two columns.My columns are "A:AC".

    i need expert advice where i will add extra line of code that will do both work like insert row and also column.

    My english is not good. so i beg your pardon.
    regards
    Last edited by sheryar; 12-23-2009 at 12:10 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1