+ Reply to Thread
Results 1 to 2 of 2

Same code not working - copying non-contiguous range

  1. #1
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    Same code not working - copying non-contiguous range

    I have a code that copies non-contiguous cells and pastes into the next empty row of another sheet. I've copied the code and added it to another workbook, altered the necessary bits (sheet names and cells) but it doesn't work. I really cannot understand why. Any help or thoughts?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,160

    Re: Same code not working - copying non-contiguous range

    When yous say "but it doesn't work", how doesn't work? What does it do that it shouldn't do, or what doesn't it do that it should. What's the difference in the data structure and content?

    It's rather difficult to guess at the solution without a) seeing an example of the code and data where it does work and b) an example where it doesn't.

    If the code works, in principle, then presumably it's data related.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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