+ Reply to Thread
Results 1 to 5 of 5

Macro fix (Copy 0's to another tab)

  1. #1
    aiwnjoo
    Guest

    Macro fix (Copy 0's to another tab)

    The macro is almost there but just needs fine tuning;

    Please Login or Register  to view this content.
    Also another variation;

    Please Login or Register  to view this content.
    The first one is the most recent, althought the 2nd one did the trick pretty much except;

    When i add that to the sheet i want the macro to run from;

    http://img293.imageshack.us/img293/3235/exampleg.jpg

    What happens is i enter a 0 into O on the sheet and it pastes into the Zeros sheet at another column number, not O but the sheet is an identical duplicate.

    The 2nd macro works perfectly but like this one, i i enter a 0 on the next cell down in O it pastes over the previous one in Zeros instead of moving down to the next unoccupied cell.

    Hope you can assist.
    Last edited by aiwnjoo; 07-16-2010 at 06:12 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,894

    Re: Macro fix (Copy 0's to another tab)

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    aiwnjoo
    Guest

    Re: Macro fix (Copy 0's to another tab)

    Thanks, so on here i presume i add in the check for 0's?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,894

    Re: Macro fix (Copy 0's to another tab)

    What I got on first reading your post was that you were having problems moving down to the next row.
    The lines:
    Please Login or Register  to view this content.
    were meant to be added to the top of the macro to calc the new destination row.
    The line:
    Please Login or Register  to view this content.
    was meant to replace: Sheets("Zeros").Range("O" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlValue
    because it looks funny.

  5. #5
    aiwnjoo
    Guest

    SOLVED Re: Macro fix (Copy 0's to another tab)

    awesome, thanks.

+ Reply to Thread

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