Results 1 to 10 of 10

EntireRow copy/paste won't stop

Threaded View

  1. #2
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Re: EntireRow copy/paste won't stop

    because the active sheet now is not sheet a anymore
    maybe try like this:

    Dim cel As Range
        Worksheets("sheet a").Activate
        For Each cel In Range("f2:f1000")
            If cel.Value = "y" Then
            cel.EntireRow.Copy
            Worksheets("sheet b").Activate
            ActiveSheet.Paste
            Application.CutCopyMode = False
            ActiveCell.Offset(1, 0).Select
            End If
           Worksheets("sheet a").Activate
        Next
    FYI, it will show you sheet a and sheet b back n forth.

    If you know what row to be pasted in sheet b, (the last blank row, for example)
    the code can be modified.
    Last edited by karmapala; 09-23-2021 at 02:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code to stop cut copy paste and other keys
    By nr6281 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-17-2021, 06:40 PM
  2. [SOLVED] Copy entirerow from a Workbook & paste into another
    By noboffinme in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2019, 09:37 PM
  3. VBA to copy/paste down values and stop at row with text
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2015, 07:11 AM
  4. [SOLVED] Cut, Copy or Paste causes excel to stop responding.
    By Jimizx in forum Excel General
    Replies: 2
    Last Post: 10-19-2012, 09:43 PM
  5. copy/paste entirerow based on listitems
    By GregJG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2008, 08:47 AM
  6. Stop users from Cut/Copy & Paste
    By rmcveigh in forum Excel General
    Replies: 2
    Last Post: 11-21-2006, 04:09 PM
  7. How to stop formulas from incrementing when you copy and paste?
    By Kirkwill in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 02: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1