Results 1 to 10 of 10

Thread: inserting a row(empty) afther each 4 rows of my data

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member saied's Avatar
    Join Date
    Jan 2015
    Posts
    5
    Rep Power
    0

    inserting a row(empty) afther each 4 rows of my data

    hi i want a code that do like this record macro and will continue up to end
    please send me acode

    Code:
    '
    ' Macro10 Macro
    '
    ' Keyboard Shortcut: Ctrl+b
    '
        Rows("5:5").Select
        Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
        Rows("10:10").Select
        Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
        Rows("15:15").Select
        Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
        Rows("20:20").Select
    2.jpg1.jpg
        End Sub
    Last edited by saied; 02-05-2015 at 12:10 PM.

Similar Threads

  1. Replies: 2
    Last Post: 03-08-2014, 02:49 AM
  2. Skip empty row and fetch values from other rows
    By dhivya.enjoy in forum Excel Help
    Replies: 1
    Last Post: 11-08-2013, 07:44 PM
  3. Sending Data From User Form To First Empty Row Of Sheets
    By paul_pearson in forum Excel Help
    Replies: 21
    Last Post: 08-14-2013, 11:04 PM
  4. Replies: 5
    Last Post: 07-11-2013, 07:31 AM
  5. Delete Empty Rows
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-28-2011, 02:13 AM

Posting Permissions

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