Results 1 to 2 of 2

copy paste row or range of cells

Threaded View

tahano54 copy paste row or range of... 03-25-2014, 03:06 PM
JOHN H. DAVIS Re: Elephant in the room 03-25-2014, 03:09 PM
  1. #1
    Registered User
    Join Date
    12-22-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    7

    Unhappy copy paste row or range of cells

    Not a expert in programming, but not a newbie either. Can understand the logic but miss the syntax sometimes. Have gone through post pertaining to copying and pasting a row from one sheet to another and tried multiple approaches. This should be a simple process.
    I have one sheet with 6 cols of decimal numbers.
    Picture1.gif
    Then I have a second sheet that represents a binary equivalent of a decimal number.
    Picture2.gif
    The goal is to read a value (i.e. A1) on sheet Decimal and based on the value choose the corresponding row from sheet Binary and copy that row to a third sheet named TestCol1.
    Used a Case Select statement which works but code in each case does not work (which now that I type it case may not be best), but be what it may.
    Individual case code is:

    Case 3
    'Cut and Paste
    Sheets(“Binary”).Rows(tmp).EntireRow.Select
    Sheets(“Binary”).Rows(tmp).EntireRow.Copy
    Sheets(outSheet).Cells(outputRow, outputCol).Select
    Sheets(outSheet).Paste
    'Set to read next Number
    inputRow = inputRow + 1
    'Set to output next row
    outputRow = outputRow + 1

    I have tried multible approches but keep getting error messages out of range (9) or 1004
    Used Worksheets.Sheets(.......
    changed to Worksheets.Sheets(.......)Range.(cells(tmp,inputCol),cells(tmp,inputCol+5).select or copy
    Doesn't work.



    Would someone please point out the elephant for me please.

    Thank you
    Last edited by tahano54; 03-25-2014 at 07:27 PM. Reason: edit post

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Chat Room
    By Workle in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-10-2015, 09:22 AM
  2. [SOLVED] Run Out Room On If Statements
    By timbo1957 in forum Excel General
    Replies: 3
    Last Post: 07-24-2012, 11:51 AM
  3. How many people were in my room?
    By jack6602 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 07-25-2010, 01:16 PM
  4. room schedule
    By jenn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1