+ Reply to Thread
Results 1 to 4 of 4

VBA code to insert alternate blank rows to every sheet except main(Sheet1)

  1. 10-11-2022, 10:56 AM #1
    zelda13
    zelda13 is offline
    Registered User
    Join Date
    08-15-2021
    Location
    Saudi Arabia
    MS-Off Ver
    2016 & 365
    Posts
    26

    VBA code to insert alternate blank rows to every sheet except main(Sheet1)

    Hi Guys,

    I need a VBA code to insert alternate blank rows to every sheet except main(Sheet1).
    That would be included on below VBA code.

    Please Login or Register  to view this content.



    See attached sample.

    Note: sample_2 is the desired outcome.

    Your help is greatly appreciated.
    Attached Files Attached Files
    Last edited by zelda13; 10-11-2022 at 11:30 PM.
    Reply With QuoteRegister To Reply
  2. 10-11-2022, 01:57 PM #2
    beyond Excel
    beyond Excel is offline
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: VBA code to insert alternate blank rows to every sheet except main(Sheet1)

    Hello.
    Let's see if that works for you?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 10-11-2022, 11:29 PM #3
    zelda13
    zelda13 is offline
    Registered User
    Join Date
    08-15-2021
    Location
    Saudi Arabia
    MS-Off Ver
    2016 & 365
    Posts
    26

    Re: VBA code to insert alternate blank rows to every sheet except main(Sheet1)

    Thank you so much for the help.
    Reply With QuoteRegister To Reply
  4. 10-11-2022, 11:48 PM #4
    beyond Excel
    beyond Excel is offline
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: VBA code to insert alternate blank rows to every sheet except main(Sheet1)

    Quote Originally Posted by zelda13 View Post
    Thank you so much for the help.
    I'm glad you liked it: until next time!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Populating a cell from a main sheet to a sub sheet and leaving out blank rows
    By Mihaka in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2021, 03:10 AM
  2. How can I insert a row in Sheet1 from code in Sheet2 without Selecting Sheet 1 first?
    By JeffLeites in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2020, 10:58 PM
  3. Macro to copy rows from sheet1 insert to another sheet
    By goya in forum Excel General
    Replies: 0
    Last Post: 12-09-2015, 03:00 PM
  4. Insert Rows if data is missing from main sheet
    By SAFC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2015, 06:42 PM
  5. [SOLVED] insert alternate blank columns
    By kuntalnr in forum Excel General
    Replies: 1
    Last Post: 02-21-2014, 11:21 AM
  6. [SOLVED] Take Data From Column on Sheet1 and Insert Into Next Blank Row on Sheet2 Then Clear Sheet1
    By abutler911 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 06:30 PM
  7. [SOLVED] HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST?
    By Phil A. in forum Excel General
    Replies: 2
    Last Post: 04-19-2005, 12:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1