+ Reply to Thread
Results 1 to 2 of 2

Transfer from WS to WS range not working properly

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Transfer from WS to WS range not working properly

    Good day, (Happy New Year)
    I was wondering what I was doing wrong with the following transfer code. I need to be able to range only my A2 and not my A1 as I have tittles in my Row A1 to R1.
    Every time I have nothing in my A2 to R2 it will take A1 to R1 instead. What would I need to change so that only my A2 to R2 to be copied and not A1 to R1:

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Transfer from WS to WS range not working properly

    Check what LastRow is, if it's 1 exit the sub.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF-THEN-ELSE not working properly
    By danex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-02-2013, 11:15 AM
  2. Replies: 10
    Last Post: 09-17-2013, 11:52 PM
  3. VBA not working properly
    By stevemills04 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2013, 02:56 PM
  4. Cells Range Reference not working properly
    By danny2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2009, 05:49 AM
  5. UDF not working properly
    By demuro1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2008, 04:36 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