Results 1 to 6 of 6

VBA Macro copy paste inserts blank row

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    365
    Posts
    184

    VBA Macro copy paste inserts blank row

    Hi,

    In the attached workbook, on the sheet named "Closed Adjustments" when the "RUN" button is clicked it copies the data from this sheet in to corresponding sheets matching the code in column I.

    Everything works fine but as you can see if you click "RUN", this inserts a blank Row 5 between the headings and the copied data only on the numbered sheets and not the main sheet. I've tried changing the code but now need help.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Some help with copy/paste to next blank line macro
    By bbennett77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2017, 01:33 AM
  2. [SOLVED] Copy last 3 columns, paste into next blank column macro
    By rossp1977 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-16-2015, 11:06 AM
  3. Macro: Copy/Paste values From Column to Next Blank Row
    By Lisseth225 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2014, 05:39 PM
  4. [SOLVED] Macro to copy and paste sepcial into next blank row
    By CharlieZangel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2013, 04:24 PM
  5. [SOLVED] copy/paste macro to selected blank cells
    By fumc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2012, 10:08 PM
  6. [SOLVED] Copy and paste macro-blank cells thereafter.
    By Bikernick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2006, 12:00 PM
  7. Macro copy and paste = blank worksheet
    By efface in forum Excel General
    Replies: 1
    Last Post: 04-27-2006, 04:52 PM

Tags for this Thread

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